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