RE: Physical read too large

This is your opportunity to contribute to the body of knowledge; log a TAR...

> This is HP True64Unix with Oracle 8.1.7
> I found nothing in metalink
>
> Ofer
>
> -----Original Message-----
> Sent: Tuesday, October 22, 2002 4:14 PM
> To: Multiple recipients of list ORACLE-L
>
>
> What version and platform you are on?
> Sounds like a bug...
> There have been a few related to huge values reported by
> v$sysstat... Anything on Metalink?
>
> - Kirti
>
> -----Original Message-----
> Sent: Tuesday, October 22, 2002 6:19 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Our data warehouse return this mysterious result:
> SQL> select *
> 2 FROM v$sysstat
> 3 WHERE name = 'physical reads'
> 4 or name = 'db block gets'
> 5 or name = 'consistent gets'
> 6 ;
>
> STATISTIC# NAME CLASS VALUE
> ----------
> ----------------------------------------------------
> 38 db block gets 8 6809493346
> 39 consistent gets 8 28857032917
> 40 physical reads 8 1.84467440704754E19
>
> Look at the parameter "physical reads" - How it can be so
> large?
> regards
>
> Ofer Harel
> DBA team
> Barak ITC
> oharel_at_barak013.net.il
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com --
> Author: Ofer Harel
> INET: oharel_at_barak013.net.il
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com San Diego, California --
> Mailing list and web hosting services
> ----------------------------------------------------------
> ----------- 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). --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com --
> Author: Deshpande, Kirti
> INET: kirti.deshpande_at_verizon.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com San Diego, California --
> Mailing list and web hosting services
> ----------------------------------------------------------
> ----------- 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). --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com --
> Author: Ofer Harel
> INET: oharel_at_barak013.net.il
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com San Diego, California --
> Mailing list and web hosting services
> ----------------------------------------------------------
> ----------- 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: tim_at_sagelogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).