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