Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: V$LOCK.TYPE = 'TO' --> What's this?
Thank you very much for this answer!
-- OpenVMS 7.3-1, Oracle 8.1.7.4 Syltrem http://pages.infinit.net/syltrem (OpenVMS related web site - en français) To reply to myself directly, remove zulu from my address "Yong Huang" <yong321_at_yahoo.com> a écrit dans le message de news:b3cb12d6.0306171010.344d7761_at_posting.google.com...Received on Tue Jun 17 2003 - 15:54:04 CDT
> 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