RE: breakable parse lock

From: <Satheesh.Babu_at_iflexsolutions.com>
Date: Mon, 5 Jul 2004 12:03:24 +0530
Message-ID: <10898BE7CA96D611988B000802255AAF06F6B4A7@fmgrt.rt.i-flex.com>

X$KG,
Am I right in saying X$KGLLK.KGLLKMOD=3D1 will show me what are all the objects in breakable parse locks mode?

Thanks and Regards,
Satheesh Babu.S
Associate Consultant.
080-57593938
Bangalore.
India.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of K Gopalakrishnan Sent: Monday, July 05, 2004 11:03 AM
To: oracle-l_at_freelists.org
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_at_fine.ae> wrote:
  > Hi,
  > Can some one put light on this please,
  > what is the difference between
  > breakable parse lock and ddl lock(exclusive/shared)
  >=20
  > why there should be TM lock while=20
  > exclusive ddl lock is auquired
  >=20
  > Thanks in advance
  > Syed
  >
  

=3D=3D=3D=3D=3D
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/

=09

        =09

---

Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail=20

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Jul 05 2004 - 01:25:48 CDT