|
Re: Concurrent Record Access [message #373769 is a reply to message #373764] |
Mon, 07 May 2001 13:29 |
Miguel
Messages: 14 Registered: April 2001
|
Junior Member |
|
|
try this:
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
|
|
|
|