OraFAQ Forum: Performance Tuning » how to unpin a table from cache

Home » RDBMS Server » Performance Tuning » how to unpin a table from cache

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to unpin a table from cache [message #347070]

Wed, 10 September 2008 10:13

ArvindBhope
Messages: 55
Registered: June 2008

Member

Guys,

Is there any way to unpin a table from cache... please let me know.

thanks,
AB

Report message to a moderator

Re: how to unpin a table from cache [message #347076 is a reply to message #347070]

Wed, 10 September 2008 10:21

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Please rephrase the question.
Term "Unpin" has several contexts.

Report message to a moderator

Re: how to unpin a table from cache [message #347078 is a reply to message #347070]

Wed, 10 September 2008 10:26

ArvindBhope
Messages: 55
Registered: June 2008

Member

ALTER TABLE SYMCDM.QUOTE_ITEM_FACT STORAGE (buffer_pool keep);

Now I want this to remove from cache...
please let me know.
thanks mahesh for instant reply ...

thanks,
arvind

Report message to a moderator

Re: how to unpin a table from cache [message #347080 is a reply to message #347070]

Wed, 10 September 2008 10:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

ALTER TABLE SYMCDM.QUOTE_ITEM_FACT STORAGE (buffer_pool default);

[Updated on: Wed, 10 September 2008 10:34] by Moderator

Report message to a moderator

Previous Topic:	A performance test of Oracle Analtyicals vs Group By
Next Topic:	use of index in performance tuning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 27 20:29:41 CDT 2024