| LRU List [message #267004] |
Wed, 12 September 2007 04:22  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
Hi,
Given below is the Oracle saying Oracle Database buffer management,
| Quote: | The buffers in the cache are organized in two lists: the write list and the least recently used (LRU) list. The write list holds dirty buffers, which contain data that has been modified but has not yet been written to disk. The LRU list holds free buffers, pinned buffers, and dirty buffers that have not yet been moved to the write list. Free buffers do not contain any useful data and are available for use. Pinned buffers are currently being accessed.
If the user process finds a dirty buffer as it searches the LRU list, it moves that buffer to the write list and continues to search. When the process finds a free buffer, it reads the data block from disk into the buffer and moves the buffer to the MRU end of the LRU list.
If an Oracle user process searches the threshold limit of buffers without finding a free buffer, the process stops searching the LRU list and signals the DBW0 background process to write some of the dirty buffers to disk.
|
I have some doubts based on this,please clear it,
1) Where the threshold limit for searching free buffers is set? How can i get value for this threshold limit?
2) Is Write List nothing but MRU List?
3) How long the pinned block will be in cache whether till the transaction completion or session completion?
Thanks...
[Updated on: Wed, 12 September 2007 04:49] by Moderator Report message to a moderator |
|
|
|
| Re: LRU List [message #267019 is a reply to message #267004] |
Wed, 12 September 2007 04:58  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
First, always post a link or a clear reference to where you read something, then we can read the same thing and its context.
1) Threshold is internal, you don't have to know it
2) No, it has nothing to do with a MRU or LRU list
3) Blocks are there till they are not aged out. maybe seconds, hours, days, months. It depends on your activity.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
