Look in v$fixed_view_definition for the
SQL that defines gv$sga_target_advice.
As a short term measure on a test db,
you can always create your own gv$
and v$ views to overwrite the proper
ones.
--
Regards
Jonathan Lewis
Now waiting on the publishers: Cost Based Oracle - Volume 1
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 8th July 2005
"Mladen Gogala" <gogala_at_sbcglobal.net> wrote in message
news:pan.2005.08.15.05.02.27.406875_at_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 - 01:45:40 CDT
