RE: Forcing a re-plan
- From: "Timur Akhmadeev" <Akhmadeev@xxxxxxxxxxxxxx>
- To: <james.barton@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 1 Oct 2008 18:28:32 +0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of James Barton
Sent: Wednesday, October 01, 2008 5:46 PM
To: oracle-l@xxxxxxxxxxxxx
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/> .
--
//www.freelists.org/webpage/oracle-l
Other related posts:
