SGA was inadequately sized, causing additional I/O or hard parses
906307Jan 10 2012 — edited Feb 2 2012My 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