Re: Shared SQL Area question

From: Michael Ho <infoage_at_hk.super.net>
Date: Sun, 11 Jul 1999 02:33:33 +0800
Message-ID: <378791FC.CC08076@hk.super.net>

Internally Oracle will create a breakable parse lock to maintain the dependency among Share SQL Area and the database objects. Any DDL cause the potential different execute plan will break the parse lock and cause the sql to parse again. Eg, creation of index, analyze the table/index.

canglin_at_anglingroup.com wrote:

> If an object referenced in SQL statement in the shared pool is modified,
> the statement is flagged as invalid. If a new object is created
> (index), does this invalidate the statement in the shared pool? If yes,
> how does Oracle know the index has been created.
>
> Thanks
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Sat Jul 10 1999 - 13:33:33 CDT