RE: URGENT - LOCK

Yep,

This is the one !!!

Thanx Mark and all others !

> -----Original Message-----
> From: Mark Leith [SMTP:mark_at_cool-tools.co.uk]
> Sent: Friday, October 27, 2000 4:18 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: URGENT - LOCK
>
> select l.kaddr kaddr,
> u.name owner,
> o.name object,
> l.sid sid,
> s.username username,
> l.type type,
> id1,
> id2,
> lmode,
> decode(lmode, 1, 'NULL', 2, 'Row Share', 3, 'Row Exclusive', 4,
> 'Share', 5, 'Share Row', 6, 'Exclusive') mode_desc,
> request,
> decode(request, 1, 'NULL', 2, 'Row Share', 3, 'Row Exclusive', 4,
> 'Share', 5, 'Share Row', 6, 'Exclusive') request_desc
> from v$lock l,
> v$session s,
> sys.obj$ o,
> sys.user$ u
> where l.type in ('RW', 'TM', 'TX', 'UL')
> and l.sid = s.sid (+)
> and l.id1 = o.obj# (+)
> and o.owner# = u.user# (+)
> order by id1,
> id2,
> lmode
> ---------------------------------
>
> HTH
>
> Mark
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
Received on Fri Oct 27 2000 - 11:12:08 CDT