| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: DDL & long-running query
I thought that the parse lock acquired by a SQL statement in the shared
pool was there to make sure that the shared SQL area gets invalidated
if a referenced schema object gets altered (or dropped). As far as I
know the parse lock does NOT prevent DDL being carried out. I
therefore believe what I originally said, i.e. that a DDL statement
does NOT have to wait on a query, to be true.
Tim Kearsley
HBS Milton Keynes
Received on Thu May 12 2005 - 08:29:21 CDT
 |
 |