Solved

V$SGA_TARGET_ADVICE view errors with zero divisor

Posted on 2009-04-06
2
669 Views
Last Modified: 2013-12-18
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
Comment
Question by:porthos_kb
2 Comments
 
LVL 40

Accepted Solution

by:
mrjoltcola earned 125 total points
ID: 24082178
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
 

Author Closing Comment

by:porthos_kb
ID: 31623684
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question