Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SGA was inadequately sized, causing additional I/O or hard parses

906307Jan 10 2012 — edited Feb 2 2012
My SGA_TARGET was set to 1168M. I was getting feedback in the "Enterprise Manager" - "Database Control" that gave a recommendation to increase this value to 1752M. I modified the MAX_SGA_TARGET to 1752M and also updated the SGA_TARGET to 1752M. I had to reboot the instance because changing the MAX_SGA_TARGET requires it to be rebooted and I wasn't able to change SGA_TARGET to 1752 untill it was <= MAX_SGA_TARGET. A few hours later I went back into "Enterprise Manager" - "Database Control" to see that it was now giving a new a recommendation to increase the SGA_TARGET from 1752M to 3080M.

I've read that this needs to hold true: [ PGA + SGA - MEMORY_REQUIRED_BY_OS - MEMORY_REQUIRED_BY_OTHER_APPLICATIONS ] < TOTAL_SYSTEM_MEMORY

How can I figure out if the above is true in my environment? I know that my SGA is now 1752M, my PGA is currently at 384M. How do I figure out MEMORY_REQUIRED_BY_OS, MEMORY_REQUIRED_BY_OTHER_APPLICATIONS and TOTAL_SYSTEM_MEMORY? This instance of Oracle is version 10g and it's running on RHEL. i was using the Linux TOP command to figure this out.

On the ADDM page of Enterprise Manager, this "SGA was inadequately sized" Impact Finding % is 6.7%. Is that something I need to be concerned with? Anyone seen SGA_TARGET this high in their environment?

Thank you in advance for any feedback,
Wes
This post has been answered by JustinCave on Jan 10 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2012
Added on Jan 10 2012
13 comments
4,211 views