Oracle Database Discussions

Hi ,

Im trying to write script to getting sid & Serial# for frequently locked objects in my database.

i have tried with 3 ways as following, Pl Guide me for choosing better.

Query 1:

SELECT SID,SERIAL# FROM V$SESSION WHERE SID IN (SELECT SID FROM V$LOCKED_OBJECT WHERE OBJECT_ID IN ('34943','34957','34966')));

Query 2:

select
sess.sid,
sess.serial#
from
v$locked_object lo,
dba_objects ao,
v$session sess
where
ao.object_id = lo.object_id
and
lo.session_id = sess.sid
AND
AO.OBJECT_ID IN('34943','34957','34966');


Query 3:

select
sid,
serial#
from
(
select
sid,
serial#
from
v$session
) y,
(
select
b.session_id
from
(
select
object_id,
session_id,
locked_mode
from
v$locked_object
) b,
(
select
object_id,
object_name,
owner
from
dba_objects
where
object_name in ('PMA_DEFECT_DETAILS',
'PMA_DEFECT_HEADER',
'PMA_DEFECT_TRANS')
) c
Where
b.object_id = c.object_id
) x
Where
x.session_id = y.sid ;

Edited by: Abk on Jan 2, 2009 6:31 PM

Edited by: Abk on Jan 2, 2009 6:34 PM