V$OBSOLETE_PARAMETER displays information about obsolete initialization parameters. If any row of the view contains TRUE in the ISSPECIFIED column, then you should examine why.
Column | Datatype | Description |
NAME | VARCHAR2(64) | Name of the parameter |
ISSPECIFIED | VARCHAR2(5) | Indicates whether the parameter was specified in the parameter file (TRUE) or not (FALSE) |
Note:
1. Obsolete parameters in Oracle 10gR2:
SQL> select NAME from V$OBSOLETE_PARAMETER order by NAME; NAME ---------------------------------------------------------------- _average_dirties_half_life _compatible_no_recovery _db_no_mount_lock _kspptbl_mem_usage _lm_direct_sends _lm_multiple_receivers _lm_statistics _oracle_trace_events _oracle_trace_facility_version _plsql_conditional_compilation _seq_process_cache_const allow_partial_sn_results always_anti_join always_semi_join arch_io_slaves b_tree_bitmap_plans backup_disk_io_slaves cache_size_threshold cleanup_rollback_entries close_cached_open_cursors complex_view_merging db_block_checkpoint_batch db_block_lru_extended_statistics db_block_lru_latches db_block_lru_statistics db_block_max_dirty_target db_file_simultaneous_writes dblink_encrypt_login delayed_logging_block_cleanouts discrete_transactions_enabled distributed_recovery_connection_hold_time distributed_transactions enqueue_resources fast_full_scan_enabled freeze_DB_for_fast_instance_recovery gc_defer_time gc_latches gc_lck_procs gc_releasable_locks gc_rollback_locks hash_join_enabled hash_multiblock_io_count instance_nodeset job_queue_interval job_queue_keep_connections large_pool_min_alloc lgwr_io_slaves lm_locks lm_procs lm_procs lm_ress lock_sga_areas log_block_checksum log_files log_parallelism log_simultaneous_copies log_small_entry_max_size max_rollback_segments max_transaction_branches mts_circuits mts_dispatchers mts_listener_address mts_max_dispatchers mts_max_servers mts_multiple_listeners mts_servers mts_service mts_sessions ogms_home ops_admin_group ops_interconnects optimizer_max_permutations optimizer_percent_parallel optimizer_search_limit oracle_trace_collection_name oracle_trace_collection_path oracle_trace_collection_size oracle_trace_enable oracle_trace_facility_name oracle_trace_facility_path parallel_broadcast_enabled parallel_default_max_instances parallel_min_message_pool parallel_server_idle_time parallel_transaction_resource_timeout partition_view_enabled plsql_native_c_compiler plsql_native_linker plsql_native_make_file_name plsql_native_make_utility push_join_predicate row_cache_cursors row_locking sequence_cache_entries sequence_cache_hash_buckets serializable shared_pool_reserved_min_alloc snapshot_refresh_interval snapshot_refresh_keep_connections snapshot_refresh_processes sort_direct_writes sort_multiblock_read_count sort_read_fac sort_spacemap_size sort_write_buffer_size sort_write_buffers spin_count standby_preserves_names temporary_table_locks text_enable transaction_auditing undo_suppress_errors use_ism 113 rows selected. |
2. ORA-32004 is usually related obsolete and/or deprecated parameters when attempting to start a database: ORA-32004: obsolete and/or deprecated parameter(s) specified. The parameter initialization file should be checked to see that none of the specified parameters match a parameter name stored in the V$OBSOLETE_PARAMETER view of that same database.