RE: Locking tables in Oracle

[Pillai, Rajesh]

Mladen,

    What does it mean if locked_mode column is populated with 0 or 3 or 6. What kind of locking does it shows (RS, X etc...)?

 

Thanks a lot,

Rajesh

-----Original Message-----
From: Gogala, Mladen [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Locking tables in Oracle

V$LOCKED_OBJECT

This view lists all locks acquired by every transaction on the system.

Column	Datatype	Description
XIDUSN	NUMBER	Undo segment number
XIDSLOT	NUMBER	Slot number
XIDSQN	NUMBER	Sequence number
OBJECT_ID	NUMBER	Object ID being locked
SESSION_ID	NUMBER	Session ID
ORACLE_USERNAME	VARCHAR2(30)	Oracle user name
OS_USER_NAME	VARCHAR2(15)	OS user name
PROCESS	VARCHAR2(9)	OS process ID
LOCKED_MODE	NUMBER	Lock mode

-----Original Message-----
From: Pillai, Rajesh [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 27, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L
Subject: Locking tables in Oracle


Hi All,
  Does anybody has any insight of dynamic view v$locked_object? It populates its locked_mode column with numbers what does those numbers mean?

TIA,
Rajesh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pillai, Rajesh
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).