|
|
| Re: How I can remove the table from cache? Which command I should execute [message #132621 is a reply to message #132401] |
Mon, 15 August 2005 04:43   |
alliejane
Messages: 59
Registered: July 2005
Location: Glasgow
|
Member |
|
|
Just to clarify for yourself.
The alter table .... nocache WILL NOT remove the table from cache.
The caching clause for a table specifies that when a table is brought into memory during a Full Table Scan oracle will place its blocks into the middle of the "least recently used" (LRU) list for the Buffer Cache.
This is contrary to its normal behaviour which is, only blocks retrieved through an index lookup are brought to the middle of the LRU list, full table scans blocks are placed at the bottom as so are aged out of memory faster.
If you have a small lookup table that is accessed regularly but is being retrieved through a FTS then the cache clause can help to retain the block in the buffer cache for longer so that the next time the query runs your server process doesn't have to go to disk.
Hope that helped a bit.
PS In 10g there is a alter system flush buffer_cache; but not in earlier releases.
Allie
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
