LRU list, checkpoint queue
buffer states:pinned,clean,free/unused,dirty
block check para: db_block_checksum db_block_checking
cache para:db_block_size,db_cache_size,db_keep_cache_size,db_recycle_cache_size,db_cache_advice
v$db_cache_advice
server read block: hash function->LRU list->dbwn write db
dbwn write checkpoint to db:checkpoint queue exeeds threshold,search LRU threshold exceeded,alter tablespace offline|begin back up,drop a segment,clean shutdown
v$buffer_pool_statistics v$buffer_pool v$db_cache_advice v$bh v$cache v$sysstat v$sesstat v$system_event v$session_wait
db_cache_size,db_keep_cache_size,db_recyle_cache_size
performance indicators:buffer busy waits>free buffer inspected>free buffer waits
buffer busy waits:data block ,undo header,undo block
free buffer waits:i/o,buffer cache size,dbwn processes
cache hit ratio: v$sysstat
multiple buffer pools:recycle pool,keep pool,default pool
define mbp:db_cache_size db_keep_cache_size db_recycle_cache_size
one segment map one pool
see buffer in pool: v$bh v$dba_objects v$buffer_pool
keep buffer pool:dbms_stats.gather_table_stats
recycle buffer pool:v$cache v$sess_io
calculating hit ratio: v$buffer_pool_statistics
cache table
multiple dbwn process:free buffer waits
assm
Oracle tuning the buffer cache
最新推荐文章于 2023-02-21 19:47:58 发布