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

Search Discussions

  • Deshpande, Kirti at Oct 22, 2002 at 2:13 pm
    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).
  • Ofer Harel at Oct 23, 2002 at 3:59 pm
    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).
  • Tim_at_sagelogix.com at Oct 23, 2002 at 4:30 pm
    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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 22, '02 at 11:18a
activeOct 23, '02 at 4:30p
posts4
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase