'from x$ksppo'에 해당되는 글 1건
- from x$ksppo 2010/03/09
|
오라클 8i 에서는 관리 목적상 없어진 파라미터들이 많이 존재합니다. 만약 이들 파라미터가 |
ORA-25138: DISTRIBUTED_LOCK_TIMEOUT initialization parameter
has been made obsolete
|
|
폐기된 파라미터들에 대한 정보는 v$obsolete_parameter 뷰에서 확인할 수 있습니다. |
SQL> select kspponm Name, decode(KSPPOFLG,1,'Eliminated', 'Underscore') Setting 2 from x$ksppo 3 order by Setting, name NAME SETTING ------------------------------------- ------------- allow_partial_sn_results Eliminated cache_size_threshold Eliminated db_block_checkpoint_batch Eliminated db_block_lru_extended_statistics Eliminated db_block_lru_statistics Eliminated db_file_simultaneous_writes Eliminated delayed_logging_block_cleanouts Eliminated job_queue_keep_connections Eliminated log_block_checksum Eliminated log_files Eliminated log_small_entry_max_size Eliminated ops_admin_group Eliminated parallel_transaction_resource_timeout Eliminated sequence_cache_entries Eliminated sequence_cache_hash_buckets Eliminated snapshot_refresh_interval Eliminated snapshot_refresh_keep_connections Eliminated snapshot_refresh_processes Eliminated sort_direct_writes Eliminated sort_read_fac Eliminated sort_spacemap_size Eliminated sort_write_buffer_size Eliminated sort_write_buffers Eliminated temporary_table_locks Eliminated arch_io_slaves Underscore b_tree_bitmap_plans Underscore backup_disk_io_slaves Underscore cleanup_rollback_entries Underscore close_cached_open_cursors Underscore compatible_no_recovery Underscore complex_view_merging Underscore discrete_transactions_enabled Underscore distributed_lock_timeout Underscore distributed_recovery_connection_hold_time Underscore fast_full_scan_enabled Underscore freeze_DB_for_fast_instance_recovery Underscore gc_latches Underscore gc_lck_procs Underscore large_pool_min_alloc Underscore lgwr_io_slaves Underscore lock_sga_areas Underscore log_archive_buffer_size Underscore log_archive_buffers Underscore log_simultaneous_copies Underscore max_transaction_branches Underscore ogms_home Underscore parallel_default_max_instances Underscore parallel_min_message_pool Underscore parallel_server_idle_time Underscore push_join_predicate Underscore row_cache_cursors Underscore shared_pool_reserved_min_alloc Underscore spin_count Underscore use_ism Underscore 54 rows selected. |
Tag : from x$ksppo