RE: Lock Type in V$LOCK

From: Yong Huang <yong321_at_yahoo.com>
Date: Thu, 23 Apr 2009 15:18:12 -0700 (PDT)
Message-ID: <159032.24663.qm_at_web80602.mail.mud.yahoo.com>


I remember lock type TO exists way back in 8i. AE is new in 11g. Views like xxx_editioning_views and the rewritten error message ORA-25001 are probably related to this.

Yong Huang

Tanel Porder wrote:

> V$LOCK_TYPE is a good starting point!
>
> SQL> select type,name,description from v$lock_type where type in ('AE',
> 'TO');
>
> TYPE NAME DESCRIPTION
> ---- --------------------
> ------------------------------------------------------------
> AE Edition Lock Prevent Dropping an edition in use
> TO Temp Object Synchronizes DDL and DML operations on a temp
> object
>
> AE is about application code versioning (editions) which should be released
> as part of Oracle 11.2 I think.
> TO is about temp tables so someone wouldn't be able to drop or alter the
> structure of the table def while there's some other session having data in
> the temp tab.
>
> --
> Tanel Poder
> http://blog.tanelpoder.com
      

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 23 2009 - 17:18:12 CDT

Original text of this message