Re: Forcing a re-plan
Even a simple "COMMENT ON TABLE <tablename> IS ' ' " will suffice to invalidate SQLs against that table and force a re-parse at the next execution. 

See http://hemantoracledba.blogspot.com/2008/07/bind-variable-peeking.html



At 09:46 PM Wednesday, James Barton wrote:

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





Hemant K Chitale
http://hemantoracledba.blogspot.com
"A 'No' uttered from the deepest conviction is better than a 'Yes' merely uttered to please, or worse, to avoid trouble." Mohandas Gandhi Quotes : http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html 

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

Other related posts: