Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 690
  • Last Modified:

V$SGA_TARGET_ADVICE view errors with zero divisor

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?
0
porthos_kb
Asked:
porthos_kb
1 Solution
 
mrjoltcolaCommented:
I think you should patch to 10.2.0.3 +

Look at your STATISTICS_LEVEL and see if they vary between databases, possibly the one you are having problems has STATISTICS_LEVEL > BASIC (ALL or TYPICAL?)

Try this Metalink bug: 4434887

Another link referring to this:

http://www.anysql.net/doc/bug10203.html

0
 
porthos_kbAuthor Commented:
All DBs are set to statistics_level=typical.  According to Oracle, failure of this view is indeed a bug that is fixed in 10.2.0.3.  Thanks.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now