RE: select * from DBA_BLOCKERS is haging forever; V 8.1.7.3; Sun OS

From: Norris, Gregory T [ITS] <gregory.t.norris_at_mail.sprint.com>
Date: Mon, 1 Mar 2004 08:55:27 -0600
Message-ID: <D24DD765BFEDB145B346ACDA71E1658B057B84F4@PKDWB04C.ad.sprint.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jay Sent: Sunday, February 29, 2004 2:07 PM
To: oracle-l_at_freelists.org
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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://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_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Mon Mar 01 2004 - 08:52:40 CST