V$SGA_TARGET_ADVICE in Oracle RDBMS 10.2
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 15 Aug 2005 01:02:33 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
