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: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Thu, 27 Mar 2003 13:08:37 -0800
Message-ID: <F001.00574AE8.20030327130837@fatcity.com>

V$LOCKED_OBJECT BM_1094230This view lists all locks acquired by every transaction on the system.

BM_1094292
BM_1094233Column	 BM_1094235Datatype	 BM_1094237Description	
BM_1094239

XIDUSN BM_1094241NUMBER BM_1094243Undo segment number

BM_1094245
XIDSLOT BM_1094247NUMBER BM_1094249Slot number

BM_1094251
XIDSQN BM_1094253NUMBER BM_1094255Sequence number

BM_1094257
OBJECT_ID BM_1094259NUMBER BM_1094261Object ID being locked

BM_1094263
SESSION_ID BM_1094265NUMBER BM_1094267Session ID

BM_1094269
ORACLE_USERNAME BM_1094271VARCHAR2(30) BM_1094273Oracle user name

BM_1094275
OS_USER_NAME BM_1094277VARCHAR2(15) BM_1094279OS user name

BM_1094281
PROCESS BM_1094283VARCHAR2(9) BM_1094285OS process ID

BM_1094287
LOCKED_MODE BM_1094289NUMBER BM_1094291Lock mode

-----Original Message-----
<mailto:Rajesh.Pillai_at_nordstrom.com> ]

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

<http://www.orafaq.net>
-- Author: Pillai, Rajesh INET: Rajesh.Pillai_at_nordstrom.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<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: Gogala, Mladen INET: MGogala_at_oxhp.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:08:37 CST

Original text of this message

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