Re: Forcing a re-plan
From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Wed, 1 Oct 2008 09:45:52 -0500 (CDT)
Message-ID: <43892.12.17.117.251.1222872352.squirrel@12.17.117.251>
Date: Wed, 1 Oct 2008 09:45:52 -0500 (CDT)
Message-ID: <43892.12.17.117.251.1222872352.squirrel@12.17.117.251>
I wish I had thought of that when I was dealing with not being able to
implement a SQL Plan (10.1 bug) to fix a bind peek problem. And the shared
DDL lock for the COMMENT shouldn't be a major issue in our environment,
either.
Thanks!
Rich
>
> 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
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 01 2008 - 09:45:52 CDT