RE: Locking tables in Oracle

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-----
Sent: Thursday, March 27, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L

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-----
Sent: Thursday, March 27, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L

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: Rajesh.Pillai_at_nordstrom.com

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: ListGuru_at_fatcity.com (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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pillai, Rajesh
  INET: Rajesh.Pillai_at_nordstrom.com

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: ListGuru_at_fatcity.com (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).