Home » RDBMS Server » Performance Tuning » cached objects in buffer
cached objects in buffer [message #258375] Sat, 11 August 2007 06:33 Go to next message
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
Michel Cadot
Messages: 64102
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
Previous Topic: Help - Histogram
Next Topic: 10g performance tuning (how can I practice?)
Goto Forum:
  


Current Time: Fri Dec 02 23:07:54 CST 2016

Total time taken to generate the page: 0.19146 seconds