| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Locking tables in Oracle
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
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.netReceived on Thu Mar 27 2003 - 15:08:37 CST
<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).
 |
 |