| keep buffer [message #501255] |
Mon, 28 March 2011 04:13  |
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  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
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 |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
