Improve company productivity with a Business Account.Sign Up

x
?
Solved

V$SGA_TARGET_ADVICE view errors with zero divisor

Posted on 2009-04-06
2
Medium Priority
?
701 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 500 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

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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

587 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