Re: Database Locks..How long?

I have had good success with this script YMMV.

set line 200
break on name skip 1
select --+ no_merge(gv$session) no_merge(x) name, round(last_call_et/60)
"idle_mins",gv$session.status,username,gv$session.inst_id,sid,serial# from gv$session, obj$,(select inst_id,session_id, object_id from gv$locked_object) x
where gv$SESSION.inst_id = x.inst_id
AND gv$session.sid = x.session_id
AND obj# = x.object_id
and flags <> 2
order by name, last_call_et desc
/

Raj

On 8/16/05, Madhavi Kanugo <MKanugo_at_ibasis.net> wrote:
>
> Hi All,
>
> Does anyone know if there is a way to find out how long a database table
> is locked? Any tips or pointers? Any help will greatly be appreciated.
>
> Thanks,
> Madhavi
>
>

--
http://www.freelists.org/webpage/oracle-l