?
Solved

Oracle 11g database undersized SGA in ADDM report

Posted on 2012-03-28
2
Medium Priority
?
3,078 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

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…
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 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.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

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