Re: Query on dba_waiters and dba_blockers hangs

Ram,

I have not observed this. When the session is "hanging", do you know on what it is waiting? - You may want to query V$SESSION_WAIT to see this.

Has this query works on any of the other databases you may have?

Shiva

On 1/3/07, Ram Raman <veeeraman_at_gmail.com> wrote:
>
> 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