Solved

Oracle 11g database undersized SGA in ADDM report

Posted on 2012-03-28
2
2,723 Views
Last Modified: 2012-03-28
Hi All,

We are seeing multiple databases that are getting undersized SGA in the ADDM reports. Luckily most of them are not seeing any VM_IN_BYTES and VM_OUT_BYTES.

Reading online we found that this may be from sql area reloads and hard parses. We are seeing 7,634 reloads in the library cache activity within an hour  and 4.1 hard parses per second in a AWR report.

We currently have 24GB of physical memory, 11.7GB allocated to SGA and 7.8GB allocated to PGA. Are there any queries that we can run to see how much more memory we will need to increase by? At what point with the sql area reload and hard parses do we need to look at buying additional memory?

Thanks for your time.
0
Comment
Question by:mw-hosting
2 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 37777652
check the memory advisor:
http://www.dba-oracle.com/oracle10g_tuning/t_memory_advisor.htm

If you don't have OEM access there are advice views:  
v$db_cache_advice
v$memory_target_advice
v$sga_target_advice
v$pga_target_advice

Probably others I've overlooked.
0
 
LVL 7

Expert Comment

by:Piloute
ID: 37777712
Hi,

The official docs might be a good starting point :

http://docs.oracle.com/cd/B28359_01/server.111/b28274/memory.htm

There's many details in there you might consider...

Cheers,
P
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
oracle report printing 2 pages in one page 2 68
Oracle 12c patching 1 80
Oracle Pivot Question 8 58
error in my cursor 5 27
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
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…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

776 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