Re: Forcing a re-plan
From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Wed, 1 Oct 2008 17:33:13 +0300
Message-ID: <6e49b6d00810010733q23dd0168jb0257ad2c18f9d6a@mail.gmail.com>
Date: Wed, 1 Oct 2008 17:33:13 +0300
Message-ID: <6e49b6d00810010733q23dd0168jb0257ad2c18f9d6a@mail.gmail.com>
Not always possible if query is in a packaged app by different vendor
or even our app made by our organization, because for example of
database restrictions (object invalidation, already executing
procedural object, wrapped code) or administrative restrictions (don't
want recompile on prod).
Gints Plivna
http://www.gplivna.eu
2008/10/1 Desai, Bhavik (MLITS) <Bhavik_Desai_at_ml.com>:
> Even a CASE change of a single letter of SQL would change the hash value and
> hence result into hard parse. It may not change the execution plan but yes,
> will hard parse the sql without flushing the shared pool.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 01 2008 - 09:33:13 CDT