Re: Database Locks..How long?
- From: rjamya <rjamya@xxxxxxxxx>
- To: MKanugo@xxxxxxxxxx
- Date: Tue, 16 Aug 2005 13:45:23 -0400
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@xxxxxxxxxx> 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
>
>
Other related posts:
