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
Thanks
arun
>From: Jared Still <jkstill_at_bcbso.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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
>with
> > 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.
>
>
>Jared
>
>----------------------------
>
>-- 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
>
>select
> 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
> INET: jkstill_at_bcbso.com
>
>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: ListGuru_at_fatcity.com (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
