Oracle-L: RE: Locking tables in Oracle

From: Arun Chakrapanirao <ArunC_at_1800FLOWERS.com>
Date: Thu, 27 Mar 2003 13:39:10 -0800
Message-ID: <F001.00574C14.20030327133910@fatcity.com>

SELECT
OWNER||'.'||OBJECT_NAME "Object",
  OS_USER_NAME "Terminal",
  ORACLE_USERNAME "Locker",
  PROGRAM "Program",
  NVL(lockwait,'ACTIVE') "Wait",
  DECODE(LOCKED_MODE,

    2, 'ROW SHARE',
    3, 'ROW EXCLUSIVE',
    4, 'SHARE',
    5, 'SHARE ROW EXCLUSIVE',
    6, 'EXCLUSIVE',  'UNKNOWN') "Lockmode",

  OBJECT_TYPE "Object Type",
  SESSION_ID "Session ID",
  SERIAL# "Serial",
  c.SID
FROM

  SYS.V_$LOCKED_OBJECT A,
  SYS.ALL_OBJECTS B,
  SYS.V_$SESSION c

WHERE
A.OBJECT_ID = B.OBJECT_ID AND
C.SID = A.SESSION_ID
ORDER BY 1 ASC, 5 Desc
-----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: Arun Chakrapanirao
INET: ArunC_at_1800FLOWERS.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------