statspack problem

From: hastenthunder <hastenthunder_at_hotmail.com>
Date: Fri, 14 Jan 2005 10:23:18 -0500
Message-ID: <GtRFd.2422$Ny6.4012@mencken.net.nih.gov>

Hello,

I'm encountering difficulites on getting statspack to generate reports on Oracle 10g + RedHat Enterprise 3.

After taking 2 snapshots, I tried to generate report by calling $ORACLE_HOME/rdbms/admin/spreport, and entered the appropriate snapshot ids upon the prompt.

The reports runs for couple seconds, then encounters a divide-by-zero error, and terminates:

    Statistic                                      Total  per Hour
--------------------------------- ------------------ ---------
log switches (derived)                             0       .00
          -------------------------------------------------------------
                    , 'D'  , size_for_estimate*1024/:def_cache
                                                                        *

ERROR at line 10:
ORA-01476: divisor is equal to zero

Can someone help me out here?

Thanks. Received on Fri Jan 14 2005 - 09:23:18 CST