Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Where to find information about LOCK_TYPE?

Where to find information about LOCK_TYPE?

From: Randi Wølner <randiwolner_at_hotmail.com>
Date: Fri, 15 Aug 2003 11:01:20 +0200
Message-ID: <bhi7bs$ato$1@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.
Can anyone give me a hint on where to look?

Randi W. Received on Fri Aug 15 2003 - 04:01:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US