keep buffer [message #501255] |
Mon, 28 March 2011 04:13 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muzahid
Messages: 281 Registered: September 2004 Location: Dhaka, Bangladesh
|
Senior Member |
|
|
How can i know which objects used keep buffer cache?
|
|
|
Re: keep buffer [message #501257 is a reply to message #501255] |
Mon, 28 March 2011 04:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
The one you want to keep in the cache over the other ones.
In fact, in 99.99% of cases, you don't need any other cache than the default one.
Regards
Michel
[Updated on: Mon, 28 March 2011 04:27] Report message to a moderator
|
|
|
Re: keep buffer [message #501261 is a reply to message #501257] |
Mon, 28 March 2011 04:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muzahid
Messages: 281 Registered: September 2004 Location: Dhaka, Bangladesh
|
Senior Member |
|
|
Actually i want to know that which object now reside in keep cache
say i alter a table to storage keep, but i do not set any value in db_keep_cache_size or set db_keep_cache_size equal 0, then it obiviously keep cache is not used although the table i create with keep buffer pool.
so have any way to know, the object used keep or default buffer cache.
[Updated on: Mon, 28 March 2011 04:33] Report message to a moderator
|
|
|
|
Re: keep buffer [message #501278 is a reply to message #501268] |
Mon, 28 March 2011 05:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muzahid
Messages: 281 Registered: September 2004 Location: Dhaka, Bangladesh
|
Senior Member |
|
|
That is the question
if i create or alter table with keep buffer_pool in storage clause
and do not set db_keep_cache_size any value,
then the dba_tables.buffer_pool see me keep although keep buffer is not use.
|
|
|
|