Oracle tuning the buffer cache

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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值