在学习过程记录的一些隐含参数记录在此.

set linesize 120
col name for a30
col value for a20
col describ for a60
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 '%&par%'
/

-- _ksmg_granule_size ( granule size deponds on SGA Size )

-- smm

-- pool_size

-- pga_max

-- _spin_count ( Amount to spin waiting for a latch )

-- _db_block_lru_latches ( number of lru latches )

-- _db_block_hash_buckets ( Number of database block hash buckets )

-- _db_block_hash_latches

-- hash_latches ( Number of database block hash latches )

-- _kghdsidx_count ( max kghdsidx count, shared pool中子缓冲池的数量)

-- _small_table_threshold ( threshold level of table size for direct reads, oracle用来判断是大表和小表的界限 )

-- _log_simultaneous_copies( redo copy latch 的数量 )

-- _log_io_size （ Redo buffer中使用的块大于或等于这个参数，会触发 LGWR )

-- _wait_for_sync ( 和Redo File Sync等待有关 )

-- _disable_logging ( 关闭数据库日志记录)

-- _allow_resetlogs_corruption ( 在不一致性下强制打开数据库 )

-- _undo_autotune ( enable auto tuning of undo_retention )

-- _collect_undo_stats ( Collect Statistics v$undostat )

[@more@]

ITPub博客

隐藏参数

最新文章