查看隐含参数

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%'


NAME					 VALUE				DESCRIB
---------------------------------------- ------------------------------ ----------------------------------------------------------------------
gcs_server_processes			 0				number of background gcs server processes to start
_lm_use_gcr				 TRUE				use GCR module if TRUE
_gcs_testing				 0				GCS testing parameter
_gcs_pkey_history			 4000				number of pkey remastering history
_gcs_fast_reconfig			 TRUE				if TRUE, enable fast reconfiguration for gcs locks
_gcs_resources								number of gcs resources to be allocated
_gcs_latches				 0				number of gcs resource hash latches to be allocated per LMS process
_gcs_process_in_recovery		 TRUE				if TRUE, process gcs requests during instance recovery
_scatter_gcs_resources			 FALSE				if TRUE, gcs resources are scattered uniformly across sub pools
_gcs_res_per_bucket			 16				number of gcs resource per hash bucket
_gcs_shadow_locks							number of pcm shadow locks to be allocated
_scatter_gcs_shadows			 FALSE				if TRUE, gcs shadows are scattered uniformly across sub pools
_gcs_disable_remote_handles		 FALSE				disable remote client/shadow handles
_gc_use_cr				 TRUE				if TRUE, allow CR pins on PI and WRITING buffers
_gc_undo_affinity			 TRUE				if TRUE, enable dynamic undo affinity
_gc_policy_time 			 10				how often to make object policy decisions in minutes
_gc_policy_minimum			 1500				dynamic object policy minimum activity per minute
_gc_affinity_ratio			 50				dynamic object affinity ratio
_gc_transfer_ratio			 2				dynamic object read-mostly transfer ratio
_gc_integrity_checks			 1				set the integrity check level
_gc_vector_read 			 TRUE				if TRUE, vector read current buffers
_gc_element_percent			 110				global cache element percent
_gc_latches				 8				number of latches per LMS process
_gc_statistics				 TRUE				if TRUE, kcl statistics are maintained
_gc_keep_recovery_buffers		 TRUE				if TRUE, make single instance crash recovery buffers current
_gc_defer_time				 3				how long to defer pings for hot buffers in milliseconds
_gc_defer_ping_index_only		 TRUE				if TRUE, restrict deferred ping to index blocks only
_gc_check_bscn				 TRUE				if TRUE, check for stale blocks
_gc_global_lru				 AUTO				turn global lru off, make it automatic, or turn it on
_gc_global_lru_touch_count		 5				global lru touch count
_gc_global_lru_touch_time		 60				global lru touch time in seconds
_gc_coalesce_recovery_reads		 TRUE				if TRUE, coalesce recovery reads
_gc_maximum_bids			 0				maximum number of bids which can be prepared
_gc_async_memcpy			 FALSE				if TRUE, use async memcpy
_gc_global_checkpoint_scn		 TRUE				if TRUE, enable global checkpoint scn
_gc_undo_block_disk_reads		 TRUE				if TRUE, enable undo block disk reads
_gc_long_query_threshold		 0				threshold for long running query
_gc_affinity_locking			 TRUE				if TRUE, enable object affinity
_gc_affinity_locks			 TRUE				if TRUE, get affinity locks
_gc_read_mostly_locking 		 TRUE				if TRUE, enable read-mostly locking
_gc_bypass_readers			 TRUE				if TRUE, modifications bypass readers
_gc_max_downcvt 			 256				maximum downconverts to process at one time
_gc_tsn_undo_affinity			 TRUE				if TRUE, use TSN undo affinity
_gc_fusion_compression			 1536				compress fusion blocks if there is free space
_gc_down_convert_after_keep		 TRUE				if TRUE, down-convert lock after recovery
_gc_delta_push_objects			 0				objects which use delta push
_gc_delta_push_max_level		 100				max delta level for delta push
_gc_delta_push_compression		 3072				if delta >= K bytes, compress before push
_gc_flush_during_affinity		 TRUE				if TRUE, flush during affinity
_gc_cr_server_read_wait 		 TRUE				if TRUE, cr server waits for a read to complete
_gc_read_mostly_flush_check		 FALSE				if TRUE, optimize flushes for read mostly objects
_backup_kgc_scheme			 ZLIB				specifies compression scheme
_backup_kgc_bufsz			 0				specifies buffer size to be used by BASIC compression
_backup_kgc_type			 0				specifies compression type used by kgc BASIC compression
_backup_kgc_niters			 0				specifies number of iterations done by BASIC compression
_backup_kgc_perflevel			 1				specifies compression (performance) level for MEDIUM compression
_backup_kgc_windowbits			 15				specifies window size for MEDIUM compression
_backup_kgc_memlevel			 8				specifies memory level for MEDIUM compression
_backup_kgc_blksiz			 9				specifies buffer size to be used by HIGH compression
_srvntfn_q_msgcount			 50				srvntfn q msg count for job exit
_srvntfn_q_msgcount_inc 		 100				srvntfn q msg count increase for job submit

61 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%'