When a block is aged out from buffer cache?

sakthikumar
sakthikumar used Ask the Experts™
on
Just wanted to know, when a block is aged out from buffer, once it is read from disk,

What kind of mechanism is followed, is there any way I can change the rule?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Refer this link for review of parameters to be considered for aging..

http://dbpedias.com/wiki/Oracle:Buffer_Pools_-_Overview


From Oracle10g, Oracle has introduced a concept of PIN.. where in you can PIN objects in Shared memory, but this can be applied to packages,functions..
Commented:
"Just wanted to know, when a block is aged out from buffer, once it is read from disk,

What kind of mechanism is followed, is there any way I can change the rule?"

Check this

http://avdeo.com/2008/06/26/touch-count-for-buffer-cache/

http://shallahamer-orapub.blogspot.com/2010/01/mystery-surrounding-11g-and-direct.html

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial