RE: breakable parse lock

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Mon, 5 Jul 2004 09:32:31 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNEEJGCFAA.lex.de.haan@naturaljoin.nl>

the DDL locks protect the row cache and the library cache; the DML locks protect the actual data (tables, rows) hope this helps,  

Kind regards,
Lex.  

---

visit my website at http://www.naturaljoin.nl

---

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Sultan Syed Sent: Monday, July 05, 2004 07:08
To: oracle-l_at_freelists.org
Subject: Re: breakable parse lock

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

---

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 - 02:29:19 CDT