V$SGA_TARGET_ADVICE in Oracle RDBMS 10.2

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 15 Aug 2005 05:02:33 GMT
Message-Id: <pan.2005.08.15.05.02.27.406875@sbcglobal.net>

Select from V$SGA_TARGET_ADVICE fails on Oracle 10.2 for Linux. The error reported is about division by zero:

SQL> select * from v$sga_target_advice;
select * from v$sga_target_advice

                                *

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

I discovered this by attempting to run STATSPACK. Of course, it bombed out with the same error. SGA parameters are like this:

SQL> show parameter sga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 400M
sga_target                           big integer 352M

Does anybody have any idea? Is this just one of the "features"? Statspack is fairly important tool and I'd hate to run a production system on something like this. The description of this table is here:

V$SGA_TARGET_ADVICE V$SGA_TARGET_ADVICE provides information about the SGA_TARGET initialization parameter.

Column 	Datatype 	Description
SGA_SIZE 	NUMBER 	Size of the SGA
SGA_SIZE_FACTOR 	NUMBER 	Ratio between the SGA_SIZE and the current size of the SGA
ESTD_DB_TIME 	NUMBER 	Estimated DB_TIME for this SGA_SIZE
ESTD_DB_TIME_FACTOR 	NUMBER 	Ratio between ESTD_DB_TIME and DB_TIME for the current size of the SGA
ESTD_PHYSICAL_READS 	NUMBER 	Estimated number of physical reads

This table contains two ratios and one of them must be zero for an almost inactive database like this one. Now I know why is 10.2 out only for Linux.

-- 
http://www.mgogala.com

Received on Mon Aug 15 2005 - 00:02:33 CDT