Re: Forcing a re-plan

From: Gints Plivna <>
Date: Wed, 1 Oct 2008 17:33:13 +0300
Message-ID: <>

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

2008/10/1 Desai, Bhavik (MLITS) <>:
> 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.

Received on Wed Oct 01 2008 - 09:33:13 CDT

Original text of this message