RE: Forcing a re-plan

From: Timur Akhmadeev <Akhmadeev_at_NetCracker.com>
Date: Wed, 1 Oct 2008 18:28:32 +0400
Message-ID: <17182849A17B3C44AE01780E7B519C82026605EE@WISE.netcracker.com>


James,  

yes, starting with 10.2.0.4 (or 10.2.0.3 with one-off patch) there is dbms_shared_pool.purge
<http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28419/d_shared
_pool.htm#sthref7227> for that purpose. I've found info about it here: http://el-caro.blogspot.com/2007/10/flushing-single-cursor.html  

PS. it is #2/3 in Google "oracle purge/flush cursor" search ;)  

Regards,

Timur Akhmadeev    

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of James Barton Sent: Wednesday, October 01, 2008 5:46 PM To: oracle-l_at_freelists.org
Subject: Forcing a re-plan  

Forgive me if this is well-documented elsewhere, but I Queried The Fine

Google and couldn't find anything:  

Are there any ways of forcing a query to be replanned, other than

gathering stats on one of the queried tables, or flushing the shared

pool?  

Thanks,

James      

The content of this e-mail is confidential and may be privileged. It may be read, copied and used only by the intended recipient and may not be disclosed, copied or distributed. If you received this email in error, please contact the sender immediately by return e-mail or by telephoning +44 20 7260 2000, delete it and do not disclose its contents to any person. You should take full responsibility for checking this email for viruses. Markit reserves the right to monitor all e-mail communications through its network.

Markit and its affiliated companies make no warranty as to the accuracy or completeness of any information contained in this message and hereby exclude any liability of any kind for the information contained herein. Any opinions expressed in this message are those of the author and do not necessarily reflect the opinions of Markit.

For full details about Markit, its offerings and legal terms and conditions, please see Markit's website at http://www.markit.com
<http://www.markit.com/> .

--

http://www.freelists.org/webpage/oracle-l

 

 


--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 01 2008 - 09:28:32 CDT

Original text of this message