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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Locking tables in Oracle

RE: Locking tables in Oracle

From: Pillai, Rajesh <Rajesh.Pillai_at_nordstrom.com>
Date: Thu, 27 Mar 2003 13:28:52 -0800
Message-ID: <F001.00574B8B.20030327132852@fatcity.com>


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).
Received on Thu Mar 27 2003 - 15:28:52 CST

Original text of this message

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