RE: Lock Type in V$LOCK
- From: Yong Huang <yong321@xxxxxxxxx>
- To: tanel@xxxxxxxxxx, Marco.Gralike@xxxxxxx
- Date: Thu, 23 Apr 2009 15:18:12 -0700 (PDT)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
