查看隐含参数

SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describFROM SYS.x$ksppi x, SYS.x$ksppcv yWHERE x.inst_id = USERENV ('Instance')AND y.inst_id = USERENV ('Instance')AND x.indx = y.indxAND x.ksppinm LIKE '%gc%'NAME VALUEDESCRIB---------------------------------------- ------------------------------ ----------------------------------------------------------------------gcs_server_processes 0number of background gcs server processes to start_lm_use_gcr TRUEuse GCR module if TRUE_gcs_testing 0GCS testing parameter_gcs_pkey_history 4000number of pkey remastering history_gcs_fast_reconfig TRUEif TRUE, enable fast reconfiguration for gcs locks_gcs_resourcesnumber of gcs resources to be allocated_gcs_latches 0number of gcs resource hash latches to be allocated per LMS process_gcs_process_in_recovery TRUEif TRUE, process gcs requests during instance recovery_scatter_gcs_resources FALSEif TRUE, gcs resources are scattered uniformly across sub pools_gcs_res_per_bucket 16number of gcs resource per hash bucket_gcs_shadow_locksnumber of pcm shadow locks to be allocated_scatter_gcs_shadows FALSEif TRUE, gcs shadows are scattered uniformly across sub pools_gcs_disable_remote_handles FALSEdisable remote client/shadow handles_gc_use_cr TRUEif TRUE, allow CR pins on PI and WRITING buffers_gc_undo_affinity TRUEif TRUE, enable dynamic undo affinity_gc_policy_time  10how often to make object policy decisions in minutes_gc_policy_minimum 1500dynamic object policy minimum activity per minute_gc_affinity_ratio 50dynamic object affinity ratio_gc_transfer_ratio 2dynamic object read-mostly transfer ratio_gc_integrity_checks 1set the integrity check level_gc_vector_read  TRUEif TRUE, vector read current buffers_gc_element_percent 110global cache element percent_gc_latches 8number of latches per LMS process_gc_statistics TRUEif TRUE, kcl statistics are maintained_gc_keep_recovery_buffers TRUEif TRUE, make single instance crash recovery buffers current_gc_defer_time 3how long to defer pings for hot buffers in milliseconds_gc_defer_ping_index_only TRUEif TRUE, restrict deferred ping to index blocks only_gc_check_bscn TRUEif TRUE, check for stale blocks_gc_global_lru AUTOturn global lru off, make it automatic, or turn it on_gc_global_lru_touch_count 5global lru touch count_gc_global_lru_touch_time 60global lru touch time in seconds_gc_coalesce_recovery_reads TRUEif TRUE, coalesce recovery reads_gc_maximum_bids 0maximum number of bids which can be prepared_gc_async_memcpy FALSEif TRUE, use async memcpy_gc_global_checkpoint_scn TRUEif TRUE, enable global checkpoint scn_gc_undo_block_disk_reads TRUEif TRUE, enable undo block disk reads_gc_long_query_threshold 0threshold for long running query_gc_affinity_locking TRUEif TRUE, enable object affinity_gc_affinity_locks TRUEif TRUE, get affinity locks_gc_read_mostly_locking  TRUEif TRUE, enable read-mostly locking_gc_bypass_readers TRUEif TRUE, modifications bypass readers_gc_max_downcvt  256maximum downconverts to process at one time_gc_tsn_undo_affinity TRUEif TRUE, use TSN undo affinity_gc_fusion_compression 1536compress fusion blocks if there is free space_gc_down_convert_after_keep TRUEif TRUE, down-convert lock after recovery_gc_delta_push_objects 0objects which use delta push_gc_delta_push_max_level 100max delta level for delta push_gc_delta_push_compression 3072if delta >= K bytes, compress before push_gc_flush_during_affinity TRUEif TRUE, flush during affinity_gc_cr_server_read_wait  TRUEif TRUE, cr server waits for a read to complete_gc_read_mostly_flush_check FALSEif TRUE, optimize flushes for read mostly objects_backup_kgc_scheme ZLIBspecifies compression scheme_backup_kgc_bufsz 0specifies buffer size to be used by BASIC compression_backup_kgc_type 0specifies compression type used by kgc BASIC compression_backup_kgc_niters 0specifies number of iterations done by BASIC compression_backup_kgc_perflevel 1specifies compression (performance) level for MEDIUM compression_backup_kgc_windowbits 15specifies window size for MEDIUM compression_backup_kgc_memlevel 8specifies memory level for MEDIUM compression_backup_kgc_blksiz 9specifies buffer size to be used by HIGH compression_srvntfn_q_msgcount 50srvntfn q msg count for job exit_srvntfn_q_msgcount_inc  100srvntfn q msg count increase for job submit61 rows selected.

SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ
FROM SYS.x$ksppi x, SYS.x$ksppcv y
WHERE x.inst_id = USERENV ('Instance')
AND y.inst_id = USERENV ('Instance')
AND x.indx = y.indx
AND x.ksppinm LIKE '%gc%'