Solved

V$SGA_TARGET_ADVICE view errors with zero divisor

Posted on 2009-04-06
2
668 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
case statement in where clause 5 48
Best RAID for a BDD Oracle 4 69
VB.Net - Oracle BulkCopy from CSV Date Format 7 60
Query Records that don't match 8 42
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…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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 copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

770 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