Re: Where to find information about LOCK_TYPE?

Thanks a lot, THAT was very helpful !
I found the document here: http://www.orsweb.com/techpapers/eventsenque.pdf The reason why I call it LOCK_TYPE is that this is the name of the column containing these values in the view dba_lock (created with catblock.sql, which comes with the Oracle db software).

Thanks again!

• Randi

"Yong Huang" <yong321_at_yahoo.com> wrote in message news:b3cb12d6.0308190654.7cd72877_at_posting.google.com...
> "Randi Wølner" <randiwolner_at_hotmail.com> wrote in message
news:<bhi7bs$ato$1_at_services.kq.no>...
> > Hello,
> > I have run the script catblock.sql, and I can find out a few things when
> > executing a select * from dba_lock. But - there is also some information
> > there that I would like to know more about, but can not find. I have
spent
> > some time now searching in Oracle documentation (Tahiti), and found a
lot
> > about lock_types TM, TX, RS, RX, S, SRX and X.
> > I have been searching for information about MR - Media Recovery, RT -
Redo
> > Thread and TS - Temp Segment. I have a feeling that these lock types are
> > nothing to worry about, but I would like to know what they mean. There
are
> > also other possible values of lock_type that I could not find
information
> > about.
>
> Hi, Randi,
>
> Oracle documentation gives brief description about some common lock
> types. Unless they're new in Oracle8 and above, some obscure lock
> types are documented in Anjo Kolk's paper "Description of Oracle7 Wait
> Events and Enqueues" (not sure if you can still find it on the
> Internet). Other than that, you have to search on Metalink and/or make
> educated guess by testing.
>
> BTW, you're confusing lock types with lock modes.
>
> Yong Huang
Received on Thu Aug 21 2003 - 05:44:44 CDT