Re: breakable parse lock
- From: "Sultan Syed" <ssyed@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 5 Jul 2004 10:08:05 +0400
Thanks Gopal,
<In short breakable parse locks are library cache locks and TM locks
protect the definition of the table during DDLs.>
This is where I am confused, while doing DDL
it already acquired exclusive ddl lock to protect the
definition of the table and stop dml against the table,
then again why the TM lock.
please clarify.
Syed
----- Original Message -----
From: "K Gopalakrishnan" <kaygopal@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, July 05, 2004 9:33 AM
Subject: Re: breakable parse lock
Syed:
Breakable parse locks are library cache locks (of enqueue types L[A-P])
which are held briefly during the compilation time/parsing time of SQL
or PL/SQL codes. They are released at the end of the
compilation/parsing. They are known as breakable parse locks as they
are not released, and only can be broken when the object is un-pinned.
TM locks are held on tables during DDLs (like partition addition, Index
Rebuilds, View creation on that table, PDML and Analyze) to protect
(lock!) the definition of the table.
In short breakable parse locks are library cache locks and TM locks
protect the definition of the table during DDLs.
--- Sultan Syed <ssyed@xxxxxxx> wrote:
> Hi,
> Can some one put light on this please,
> what is the difference between
> breakable parse lock and ddl lock(exclusive/shared)
>
> why there should be TM lock while
> exclusive ddl lock is auquired
>
> Thanks in advance
> Syed
>
=====
Have a nice day !!
------------------------------------------------------------
Best Regards,
K Gopalakrishnan,
Co-Author: Oracle Wait Interface: Oracle Press 2004.
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
