Re: locking

From: John Theunis <john.theunis_at_advalvas.be>
Date: Sun, 10 Jun 2001 01:02:24 +0200
Message-ID: <9fu9r6$pnt$1@news.worldonline.be>

hi,

SELECT SESSION_ID "sid",SERIAL# "Serial", substr(OBJECT_NAME,1,20) "Object",
  substr(OS_USER_NAME,1,10) "Terminal",
  substr(ORACLE_USERNAME,1,10) "Locker",   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 "Type"
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
/

should also give you some idea

john

"Salnik Andrej" <d95014_at_htlwrn.ac.at> wrote in message news:3B223169.4F7119B5_at_htlwrn.ac.at...
> how can i display which rows / tables are locked?
> (sp_lock MS SQL-Server)
>
>
>
Received on Sat Jun 09 2001 - 18:02:24 CDT