[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

(ET)wheel horse electric on ebay....



select  /*+ rule */ 
a.object_id, B.SID, C.USERNAME, C.OSUSER, C.TERMINAL,
                DECODE(B.ID2, 0, A.OBJECT_NAME,
                        'Trans-' || to_char(B.ID1)) OBJECT_NAME,
                B.TYPE,
                DECODE(B.LMODE,0,'--Waiting--',
                                1, 'Null',
                                2, 'Row Share',
                                3, 'Row Excl',
                                4, 'Share',
                                5, 'Sha Row Exc',
                                6, 'Exclusive',
                                'Other') "Lock Mode",
                DECODE(B.REQUEST, 0, ' ',
                                1, 'Null',
                                2, 'Row Share',
                                3, 'Row Excl',
                                4, 'Share',
                                5, 'Sha Row Exc',
                                6, 'Exclusive',
                                'Other') "Req Mode"
from ALL_OBJECTS A, V$LOCK B, V$SESSION C
where A.OBJECT_ID(+) = B.ID1
AND A.OWNER = 'SYSADM'
and B.SID = C.SID
http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&item=2028545013

Asking $500.00