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.

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
alter table ... storage (buffer_pool keep);

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 22:48:10 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.