Buffer cache spillover: only buffers
Posted
by Liu Maclean(???)
on Oracle Blogs
See other posts from Oracle Blogs
or by Liu Maclean(???)
Published on Fri, 12 Oct 2012 13:08:22 +0000
Indexed on
2012/10/12
15:44 UTC
Read the original article
Hit count: 548
/Oracle
?????? (?database open)????recovery?redo??,??????????????????:
> Buffer cache spillover: only 32768 of 117227 buffers available$
????crash recovery?redo apply??????buffer cache,??buffer cache???recovery buffer? ?????recovery buffer,????????age out????????redo change???????????
????????????recovery(???crash recovery??instance recovery),?????buffer cache ??????????????(recovery)???? ??????(lock claim phase),?????????buffer cache ??spillover??????(???swap)??????????????????,oracle???????redo change???????????buffer cache????????recovery buffer????????,???????????????????? ?????????????(spillover recovery)??????????????(?????????,?????????redo apply),????????????
??????,??crash recovery???? buffer cache??????????; ?????????, ?????????????buffer cache????????,?????????????????????????,?????????????????db_cache_size???????,??alter database open??????(Buffer cache spillover: only 32768 of 117227 buffers available$),??????????????????
????????buffer cache spillover,?????????10???????????????,????????alert.log 30??????????,?????spillover???hang,?????????OTN Ask Maclean
© Oracle Blogs or respective owner