| cached objects in buffer [message #258375] |
Sat, 11 August 2007 06:33  |
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  |
 |
Michel Cadot
Messages: 68665
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
