Home » RDBMS Server » Performance Tuning » How to Ping (keep) table in db_keep_cache
How to Ping (keep) table in db_keep_cache [message #261183] Wed, 22 August 2007 02:00 Go to next message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
Hi All,

I have configured the db_keep_cache_size on my new 9i development box = 16M and then realised I didn't know how to pin the various objects in there. I have looked around but can't find the syntax.

Could anyone give me a pointer?

Can I pin (keep) tables as well as indexes in there?

Thanks in advance for any help.
Re: How to Ping (keep) table in db_keep_cache [message #261205 is a reply to message #261183] Wed, 22 August 2007 02:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alter table ... storage (buffer_pool keep);

Regards
Michel
Re: How to Ping (keep) table in db_keep_cache [message #261240 is a reply to message #261205] Wed, 22 August 2007 03:46 Go to previous message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
Hi

Thanks very much

Aslam Khalife
Previous Topic: AWR snap_id sequence
Next Topic: Help-Histogram
Goto Forum:
  


Current Time: Sun Dec 11 04:28:13 CST 2016

Total time taken to generate the page: 0.07090 seconds