Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Query on dba_waiters and dba_blockers hangs

Query on dba_waiters and dba_blockers hangs

From: Ram Raman <veeeraman_at_gmail.com>
Date: Wed, 3 Jan 2007 10:43:04 -0600
Message-ID: <effc058d0701030843n31809098j34fe27190ef54b24@mail.gmail.com>


Hi,

I am trying to query dba_waiters and dba_blockers table logged in as sysdba and the queries hang. Oracle v9206. I issued "select * from dba_waiters" and wait for 5, 6 minutes and then killed the query. Just for testing it, once I waited 30 minutes after issuing the query. There was no response, so I killed it.

Has anyone observed this behavior before.

Thanks.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 03 2007 - 10:43:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US