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: locks?

Re: locks?

From: Veera Prasad <vprasad_at_olf.com>
Date: Thu, 03 Aug 2000 10:40:21 -0400
Message-Id: <10578.113730@fatcity.com> 




--------------AA9FB475BDD54C224320E312
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit





try this below select st .....



select s.sid, s.serial#,       decode(s.process, null,


    decode(substr(p.username,1,1), '?',   upper(s.osuser), p.username),
    decode(       p.username, 'ORACUSR ', upper(s.osuser), s.process))
process,


   nvl(s.username, 'SYS ('||substr(p.username,1,4)||')') username,
  decode(s.terminal, null, rtrim(p.terminal, chr(0)),

    upper(s.terminal)) terminal,       decode(l.type,


                      'TM', 'DML/DATA ENQ',   'TX', 'TRANSAC ENQ',

                      'UL', 'PLS USR LOCK',          -- Short locks

                      'BL', 'BUF HASH TBL',  'CF', 'CONTROL FILE',

                      'CI', 'CROSS INST F',  'DF', 'DATA FILE   ',

                      'CU', 'CURSOR BIND ',

                      'DL', 'DIRECT LOAD ',  'DM', 'MOUNT/STRTUP',

                      'DR', 'RECO LOCK   ',  'DX', 'DISTRIB TRAN',

                      'FS', 'FILE SET    ',  'IN', 'INSTANCE NUM',

                      'FI', 'SGA OPN FILE',

                      'IR', 'INSTCE RECVR',  'IS', 'GET STATE   ',

                      'IV', 'LIBCACHE INV',  'KK', 'LOG SW KICK ',

                      'LS', 'LOG SWITCH  ',

                      'MM', 'MOUNT DEF   ',  'MR', 'MEDIA RECVRY',

                      'PF', 'PWFILE ENQ  ',  'PR', 'PROCESS STRT',

                      'RT', 'REDO THREAD ',  'SC', 'SCN ENQ     ',

                      'RW', 'ROW WAIT    ',

                      'SM', 'SMON LOCK   ',  'SN', 'SEQNO INSTCE',

                      'SQ', 'SEQNO ENQ   ',  'ST', 'SPACE TRANSC',

                      'SV', 'SEQNO VALUE ',  'TA', 'GENERIC ENQ ',

                      'TD', 'DLL ENQ     ',  'TE', 'EXTEND SEG  ',

                      'TS', 'TEMP SEGMENT',  'TT', 'TEMP TABLE  ',

                      'UN', 'USER NAME   ',  'WL', 'WRITE REDO  ',

                      'TYPE='||l.type) type,

       decode(l.lmode, 0, 'NONE', 1, 'NULL', 2, 'RS', 3, 'RX',
                       4, 'S',    5, 'RSX',  6, 'X',
                       to_char(l.lmode) ) lmode,
       decode(l.request, 0, 'NONE', 1, 'NULL', 2, 'RS', 3, 'RX',
                         4, 'S', 5, 'RSX', 6, 'X',
                         to_char(l.request) ) lrequest,
       decode(l.type, 'MR', decode(u.name, null,
                            'DICTIONARY OBJECT', u.name||'.'||o.name),


                      'TD', u.name||'.'||o.name,

                      'TM', u.name||'.'||o.name,

                      'RW', 'FILE#='||substr(l.id1,1,3)||

                      ' BLOCK#='||substr(l.id1,4,5)||' ROW='||l.id2,

                      'TX', 'RS+SLOT#'||l.id1||' WRP#'||l.id2,

                      'WL', 'REDO LOG FILE#='||l.id1,

                      'RT', 'THREAD='||l.id1,

                      'TS', decode(l.id2, 0, 'ENQUEUE',

                                             'NEW BLOCK ALLOCATION'),


                      'ID1='||l.id1||' ID2='||l.id2) object

from   sys.v_$lock l, sys.v_$session s, sys.obj$ o, sys.user$ u,
       sys.v_$process p




where  s.paddr  = p.addr(+)  and  l.sid    = s.sid
  and  l.id1    = o.obj#(+)  and  o.owner# = u.user#(+)  and  l.type
<> 'MR'

UNION ALL                          /*** LATCH HOLDERS ***/
select s.sid, s.serial#, s.process, s.username, s.terminal,
       'LATCH', 'X', 'NONE', h.name||' ADDR='||rawtohex(laddr)


from   sys.v_$process p, sys.v_$session s, sys.v_$latchholder h
where  h.pid  = p.pid  and  p.addr = s.paddr

UNION ALL                         /*** LATCH WAITERS ***/
select s.sid, s.serial#, s.process, s.username, s.terminal,
       'LATCH', 'NONE', 'X', name||' LATCH='||p.latchwait
from   sys.v_$session s, sys.v_$process p, sys.v_$latch l
where  latchwait is not null  and  p.addr      = s.paddr


  and  p.latchwait = l.addr;



REgards


Veera Prasad





Swapna_P wrote:


>
>
> how can i find out the locks existing on a table and by whom?
> rgds
> swapna

--------------AA9FB475BDD54C224320E312




Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit



<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>


try this below select st .....


<p>select s.sid, s.serial#,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; decode(s.process,
null,


<br>&nbsp;&nbsp;&nbsp; decode(substr(p.username,1,1), '?',&nbsp;&nbsp;
upper(s.osuser), p.username),


<br>&nbsp;&nbsp;&nbsp; decode(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; p.username,
'ORACUSR ', upper(s.osuser), s.process)) process,
<br>&nbsp;&nbsp; nvl(s.username, 'SYS ('||substr(p.username,1,4)||')')
username,


<br>&nbsp; decode(s.terminal, null, rtrim(p.terminal, chr(0)),
<br>&nbsp;&nbsp;&nbsp; upper(s.terminal)) terminal,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
decode(l.type,


<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'TM', 'DML/DATA ENQ',&nbsp;&nbsp; 'TX', 'TRANSAC ENQ',
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'UL', 'PLS USR LOCK',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
-- Short locks


<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'BL', 'BUF HASH TBL',&nbsp; 'CF', 'CONTROL FILE',
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'CI', 'CROSS INST F',&nbsp; 'DF', 'DATA FILE&nbsp;&nbsp; ',
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'CU', 'CURSOR BIND ',



<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'DL', 'DIRECT LOAD ',&nbsp; 'DM', 'MOUNT/STRTUP',

<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'DR', 'RECO LOCK&nbsp;&nbsp; ',&nbsp; 'DX', 'DISTRIB TRAN',
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


'FS', 'FILE SET&nbsp;&nbsp;&nbsp; ',&nbsp; 'IN', 'INSTANCE NUM',
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'FI', 'SGA OPN FILE',



<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'IR', 'INSTCE RECVR',&nbsp; 'IS', 'GET STATE&nbsp;&nbsp; ',
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'IV', 'LIBCACHE INV',&nbsp; 'KK', 'LOG SW KICK ',
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'LS', 'LOG SWITCH&nbsp; ',

<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'MM', 'MOUNT DEF&nbsp;&nbsp; ',&nbsp; 'MR', 'MEDIA RECVRY',
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


'PF', 'PWFILE ENQ&nbsp; ',&nbsp; 'PR', 'PROCESS STRT',
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'RT', 'REDO THREAD ',&nbsp; 'SC', 'SCN ENQ&nbsp;&nbsp;&nbsp;&nbsp; ',
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'RW', 'ROW WAIT&nbsp;&nbsp;&nbsp; ',

<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'SM', 'SMON LOCK&nbsp;&nbsp; ',&nbsp; 'SN', 'SEQNO INSTCE',
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'SQ', 'SEQNO ENQ&nbsp;&nbsp; ',&nbsp; 'ST', 'SPACE TRANSC',
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


'SV', 'SEQNO VALUE ',&nbsp; 'TA', 'GENERIC ENQ ',
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'TD', 'DLL ENQ&nbsp;&nbsp;&nbsp;&nbsp; ',&nbsp; 'TE', 'EXTEND SEG&nbsp;
',


<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'TS', 'TEMP SEGMENT',&nbsp; 'TT', 'TEMP TABLE&nbsp; ',

<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'UN', 'USER NAME&nbsp;&nbsp; ',&nbsp; 'WL', 'WRITE REDO&nbsp; ',
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


'TYPE='||l.type) type,


<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; decode(l.lmode, 0, 'NONE', 1,
'NULL', 2, 'RS', 3, 'RX',



<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
4, 'S',&nbsp;&nbsp;&nbsp; 5, 'RSX',&nbsp; 6, 'X',
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
to_char(l.lmode) ) lmode,


<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; decode(l.request, 0, 'NONE', 1,
'NULL', 2, 'RS', 3, 'RX',



<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
4, 'S', 5, 'RSX', 6, 'X',



<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
to_char(l.request) ) lrequest,


<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; decode(l.type, 'MR', decode(u.name,
null,


<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'DICTIONARY OBJECT', u.name||'.'||o.name),
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'TD', u.name||'.'||o.name,


<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'TM', u.name||'.'||o.name,


<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'RW', 'FILE#='||substr(l.id1,1,3)||


<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
' BLOCK#='||substr(l.id1,4,5)||' ROW='||l.id2,
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'TX', 'RS+SLOT#'||l.id1||' WRP#'||l.id2,
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'WL', 'REDO LOG FILE#='||l.id1,


<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'RT', 'THREAD='||l.id1,


<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'TS', decode(l.id2, 0, 'ENQUEUE',


<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'NEW BLOCK ALLOCATION'),



<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
'ID1='||l.id1||' ID2='||l.id2) object


<br>from&nbsp;&nbsp; sys.v_$lock l, sys.v_$session s, sys.obj$ o, sys.user$
u,


<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sys.v_$process p
<br>where&nbsp; s.paddr&nbsp; = p.addr(+)&nbsp; and&nbsp; l.sid&nbsp;&nbsp;&nbsp;
= s.sid


<br>&nbsp; and&nbsp; l.id1&nbsp;&nbsp;&nbsp; = o.obj#(+)&nbsp; and&nbsp;
o.owner# = u.user#(+)&nbsp; and&nbsp; l.type&nbsp;&nbsp; &lt;> 'MR'
<br>UNION ALL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
/*** LATCH HOLDERS ***/



<br>select s.sid, s.serial#, s.process, s.username, s.terminal,
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'LATCH', 'X', 'NONE', h.name||'
ADDR='||rawtohex(laddr)


<br>from&nbsp;&nbsp; sys.v_$process p, sys.v_$session s, sys.v_$latchholder
h


<br>where&nbsp; h.pid&nbsp; = p.pid&nbsp; and&nbsp; p.addr = s.paddr
<br>UNION ALL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
/*** LATCH WAITERS ***/



<br>select s.sid, s.serial#, s.process, s.username, s.terminal,
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'LATCH', 'NONE', 'X', name||'
LATCH='||p.latchwait


<br>from&nbsp;&nbsp; sys.v_$session s, sys.v_$process p, sys.v_$latch l
<br>where&nbsp; latchwait is not null&nbsp; and&nbsp; p.addr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
= s.paddr

<br>&nbsp; and&nbsp; p.latchwait = l.addr;
<p>REgards
<br>Veera Prasad
<br>&nbsp;
<br>&nbsp;
<p>Swapna_P wrote:
<blockquote TYPE=CITE>&nbsp;
<p><font face="Arial"><font color="#0000FF">how can i find out the locks


existing on a table and by whom?</font></font>
Received on Thu Aug 03 2000 - 09:40:21 CDT












Original text of this message













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