在学习过程记录的一些隐含参数记录在此.
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 )
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7319061/viewspace-1028595/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7319061/viewspace-1028595/