Re: Meaning of V$WAITSTAT statistics

Hi all

Sorry for interrupting this thread !

I'm sorry to say that it is not possible to answer since time_statistics = false and there for the time column is zero. So we know that this db has waited on
(data block 335274, segment header 52,undo header 322 and undo block 419) these different thing but we don't know for how long time and therefor we don't know if it is a problem ! Turn on time_statistics on the db and see what the wait time is then you might find that you have a problem or not

if it's not broken don't fix it

Raghu Kota wrote:

> Hi Friends
>
> My v$waitstat shows like this..I think there is no time waited..Its
> okay, Or any thing Iam missing here??
>
> SQL> select * from v$waitstat;
>
> CLASS COUNT TIME
> ------------------ ---------- ----------
> data block 335274 0
> sort block 0 0
> save undo block 0 0
> segment header 52 0
> save undo header 0 0
> free list 0 0
> system undo header 0 0
> system undo block 0 0
> undo header 322 0
> undo block 419 0
>
> Thanks
> Raghu.
>
>
>
>
>
>> From: "Mohan, Ross" <MohanR_at_STARS-SMI.com>
>> Reply-To: ORACLE-L_at_fatcity.com
>> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>> Subject: RE: RE: Meaning of V$WAITSTAT statistics
>> Date: Wed, 03 Oct 2001 07:05:20 -0800
>>
>>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at
> http://explorer.msn.com/intl.asp
>

-- 
Regards

Peter Gram

Miracle A/S 
http://MiracleAS.dk 
Tel: +45 2527 7107



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Gram
  INET: peter.gram_at_miracleas.dk

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).