RE: select * from DBA_BLOCKERS is haging forever; V 8.1.7.3; Sun OS
- From: "Norris, Gregory T [ITS]" <gregory.t.norris@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 1 Mar 2004 08:55:27 -0600
In my experience, DBA_BLOCKERS is *quite* slow... especially if there are more
than a handful of sessions holding locks. I often use the following query
instead.
select /*+ RULE */ l.session_id, s.serial#, s.username, s.status
from dba_locks l, v$session s
where l.blocking_others = 'Blocking'
and l.session_id = s.sid
order by 1;
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jay
Sent: Sunday, February 29, 2004 2:07 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: select * from DBA_BLOCKERS is haging forever; V 8.1.7.3; Sun OS
Dear All,
Any idea why "select * from DBA_BLOCKERS;" is haging forever.
Thanks
Jay
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
