Re: v$lock columns, info about rollback slot??

From: Lubomir Petrov <lpetrov_at_yahoo.com>
Date: 18 Dec 2001 19:53:03 -0800
Message-ID: <75805ad9.0112181953.28d12148@posting.google.com>

Manuela Mueller <520040906697-0001_at_t-online.de> wrote in message news:<3C1F9121.42BA60FD_at_t-online.de>...
> Sorry, forgot to follow my own advice:
> OS: LINUX 6.2
> RDBMS: Oracle 8.1.7 EE

Hi Manuela,

I think v$locked_object comes here... You can get the session id from v$lock and then query v$locked_object to get the additional info.

SQL>desc v$locked_object

Name                     Null?    Type
------------------------ -------- -----------------------
XIDUSN                            NUMBER (Undo segment number)
XIDSLOT                           NUMBER (Slot number)
XIDSQN                            NUMBER (Sequence number)
OBJECT_ID                         NUMBER
SESSION_ID                        NUMBER
ORACLE_USERNAME                   VARCHAR2(30)
OS_USER_NAME                      VARCHAR2(30)
PROCESS                           VARCHAR2(9)
LOCKED_MODE                       NUMBER  (Lock mode)

HTH
Lyubomir Petrov Received on Tue Dec 18 2001 - 21:53:03 CST