Re: Where to find information about LOCK_TYPE?

"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 Tue Aug 19 2003 - 09:54:03 CDT