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@xxxxxx>: > 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. -- //www.freelists.org/webpage/oracle-l