查看隐含参数

原创 2013年12月03日 21:38:34
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%'


版权声明:本文为博主原创文章,未经博主允许不得转载。

查看Oracle中的隐含参数

在sqlplus中使用show parameter xx可以查看到Oracle定义的参数, 它是通过查询v$parameter获得的. 另外Oracle中还有一些隐含的参数 无法直接通过show pa...

ORACLE 查看隐含参数脚本

一:首先看下查到隐含参数需要用到的两个x$表 SQL> desc x$ksppi 名称 是否为空? 类型 ------------ -------- --------------...

大亚E8C终端参数查看方法

  • 2015年06月10日 09:56
  • 1.14MB
  • 下载

查看USB相关参数TOOL

  • 2013年07月17日 10:25
  • 51KB
  • 下载

类中函数的一个隐含参数--this指针

为什么会有this指针呢?我们需要来看一段代码感受一下。#include using namespace std; class Student { public: void InitStude...

查看oracle系统参数的一些语句

  • 2011年05月06日 11:58
  • 1KB
  • 下载

VC:va_list用法---隐含参数的使用方法

va_list用法---隐含参数的使用方法及IO使用说明 目的: 掌握VA_LIST用法 熟悉输入/出的实质,要建立起IO的概念,避免输入出停留在终端阶段 设计到IO设备,便一点设计到 阻塞、...

苹果手机电池灯参数查看软件

  • 2015年04月10日 20:01
  • 5.7MB
  • 下载

查看CPU参数

  • 2014年01月07日 09:03
  • 5KB
  • 下载
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:查看隐含参数
举报原因:
原因补充:

(最多只允许输入30个字)