V$SGA_TARGET_ADVICE view errors with zero divisor
Posted on 2009-04-06
I have several Oracle 10.2.0.2 databases running in dedicated server mode, all configured with a positive SGA_TARGET parameter. For most, the SGA_TARGET_ADVICE view shows expected results. A few of the small DBs (SGA < 2G) give me a ORA-1476 error when I execute this view. Why?