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 > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com -- > Author: Ofer Harel > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
