Re: V$LOCK.TYPE = 'TO' --> What's this?

From: Yong Huang <yong321_at_yahoo.com>
Date: 17 Jun 2003 11:10:14 -0700
Message-ID: <b3cb12d6.0306171010.344d7761@posting.google.com>

Hi, Syltrem,

TO locks are locks on global temporary tables. v$lock.id1 is dba_objects.object_id. For instance, in my Apps 11i database, I currently have more than 200 TO locks all placed on applsys.MO_GLOB_ORG_ACCESS_TMP. They correspond to the rows in v$sort_usage where segtype = 'DATA'. In my case, the lock mode is 3 (row exclusive).

Because this name happens to be a common English word, it's hard to search either on Metalink or Google.

Yong Huang

"Syltrem" <syltremzulu_at_videotron.ca> wrote in message news:<dGpHa.10278$945.30102_at_tor-nn1.netcom.ca>...
> I have TO type locks in my db, and can't find what those are.
> The object is a table and it's an exclusive row-lock
>
> The article "V$LOCK" Reference Note" on Metalink does not show a type TO
Received on Tue Jun 17 2003 - 13:10:14 CDT