Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: breakable parse lock

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US