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!

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

609621Jul 13 2009 — edited Jul 13 2009
Dear all,

We are using 10g RAC On Solaris 5.10

Very freuently,we are getting the below message in DB Console
The SGA was inadequately sized, causing additional I/O or hard parses.

Additional Information 
 
The value of parameter "sga_target" was "15360 M" during the analysis period.

Under recommendations, 

I found that 

Increase the size of the SGA by setting the parameter "sga_target" to 30720 M.

Findings Path 
 
 
 
Findings Impact (%) Additional Information 
The SGA was inadequately sized, causing additional I/O or hard parses. 27 Additional Information 
Wait class "User I/O" was consuming significant database time. 13.2 
 
Hard parsing of SQL statements was consuming significant database time. 4.9 
 
Contention for latches related to the shared pool was consuming significant database time. 0.6 
 
Wait class "Concurrency" was consuming significant database time 
 
Can I rely on this info alone and increase SGA.. Is there any other way I confirm this ?.


Dear Seniors,

Please ignore this Thread if you find this question silly..

Please advise

Kai
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 10 2009
Added on Jul 13 2009
2 comments
2,250 views