addm report says less SGA then what is actually set
A.D.Dec 20 2005 — edited Dec 20 2005I found a recommendation in addm report to increase the sga_target..quoted is lines from report..(notice that bold line)
FINDING 5: 5% impact (262 seconds)
----------------------------------
The SGA was inadequately sized, causing additional I/O or hard parses.
RECOMMENDATION 1: DB Configuration, 5% benefit (262 seconds)
ACTION: Increase the size of the SGA by setting the parameter
"sga_target" to 2560 M.
ADDITIONAL INFORMATION:
The value of parameter "sga_target" was "2048 M" during the analysis
period.
SYMPTOMS THAT LED TO THE FINDING:
SYMPTOM: Hard parsing of SQL statements was consuming significant
database time. (3.3% impact [173 seconds])
SYMPTOM: Wait class "User I/O" was consuming significant database time.
(2.6% impact [135 seconds])
but the initparameter says that the SGA_TARGET=2147483648(i,e 2148MB)
Why is this inconsistancy ??