cached objects in buffer [message #258375] |
Sat, 11 August 2007 06:33 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
pramodgaree
Messages: 22 Registered: August 2007
|
Junior Member |
|
|
How can i get the information about the contents i.e what are the objects present in buffer currently.if i cache an object using alter table xxx storage(bufferpool keep) how many blocks will be cached for that object.
|
|
|
Re: cached objects in buffer [message #258396 is a reply to message #258375] |
Sat, 11 August 2007 09:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.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 |
|
|
Quote: | How can i get the information about the contents i.e what are the objects present in buffer currently
|
Query v$bh.
Quote: | if i cache an object using alter table xxx storage(bufferpool keep) how many blocks will be cached for that object.
|
No fixed number, depends on what you ask for this table, what you ask for other tables, cache size... as for default cache.
Regards
Michel
|
|
|