Home » RDBMS Server » Performance Tuning » how to unpin a table from cache
how to unpin a table from cache [message #347070] Wed, 10 September 2008 10:13 Go to next message
ArvindBhope
Messages: 55
Registered: June 2008
Member
Guys,

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

thanks,
AB
Re: how to unpin a table from cache [message #347076 is a reply to message #347070] Wed, 10 September 2008 10:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please rephrase the question.
Term "Unpin" has several contexts.
Re: how to unpin a table from cache [message #347078 is a reply to message #347070] Wed, 10 September 2008 10:26 Go to previous messageGo to next message
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
Re: how to unpin a table from cache [message #347080 is a reply to message #347070] Wed, 10 September 2008 10:34 Go to previous message
BlackSwan
Messages: 25039
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:
  


Current Time: Mon Dec 05 21:05:15 CST 2016

Total time taken to generate the page: 0.19803 seconds