Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: your mail(dba_waiters and dba_blockers hanging)

Re: your mail(dba_waiters and dba_blockers hanging)

From: ARUN K C <>
Date: Wed, 21 Jun 2000 19:24:56 PDT
Message-Id: <>

Actually there are no sessions on the database itself,the database was just brought up and when we tried to check the dba_Waiters and the dba_blockers it was hanging.We contacted oracle but no answer from them. So I wanted help from you people as to whether any of you have faced the probs
Please let me know

>From: Jared Still <>
>To: Multiple recipients of list ORACLE-L <>
>Subject: Re: your mail
>Date: Wed, 21 Jun 2000 16:54:24 -0800
>On Wed, 21 Jun 2000, ARUN K C wrote:
> > Hi all,
> > Can anybody please let me know as to whether you are facing any probs
> > dba_waiters,dba_blockers in 8.1.6,we upgraded up on of out m/c from
>7.3.4 to
> > 8.1.6,when we query the dba_waiters it hangs and even the dba_blockers
> > hang,I am not able to why this is happening.
> > Can somebody please help me out with this
>Try querying v$session_wait to see what the query is waiting on.
>-- sesswaitu.sql
>-- show current waits for a username
>-- may call as '@sesswaitu USERNAME'
>-- eg. @sesswaitu '%'
>-- eg. @sesswaitu '%TMR%'
>-- eg. @sesswaitu 'USSP'
>-- if username not passed, it will ask for it
>set line 110 feed on pause off echo off
>set trimspool on
>clear col
>clear break
>col cusername new_value uusername
>prompt Enter Username:
>set feed off echo off term off
>select '&1' cusername from dual;
>set term on feed on
>col sid format 99999
>col username format a10
>col event format a30
>col p1text format a10
>col wait_time format 999999 head 'WAIT|TIME'
>col seconds_in_wait format 999999 head 'SECONDS|IN|WAIT'
>col state format a20
>break on username skip 1 on event
> s.username username,
> e.event event,
> s.sid,
> e.p1text,
> e.wait_time,
> e.seconds_in_wait,
> e.state
>from v$session s, v$session_wait e
>where s.username is not null
> and s.sid = e.sid
> and s.username like upper('&uusername')
>order by s.username, upper(e.event)
>undef 1
>Author: Jared Still
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Received on Wed Jun 21 2000 - 21:24:56 CDT

Original text of this message