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-04-19 08:56:20 发布
本文介绍了 Oracle 数据库中缓存管理的相关概念和技术细节,包括 LRU 列表、检查点队列、缓存参数设置及不同缓存池的作用。此外还探讨了缓存命中率的计算方法以及如何通过调整参数优化缓存性能。
100

被折叠的 条评论
为什么被折叠?



