How to interpret advisories from awr reports
DEEJun 20 2012 — edited Jun 20 2012hi all,
How to interpret the various advisories from awr reports like buffer pool advisory, sga target advisory, pga memory advisory, shared pool advisory etc.,
Say for the example the transaction volume or the load on the database server is going to increase by 50%, the based on the advisories how can I proactively increase the memory parameters so that performance is not impacted.
for example,
SGA Target Advisory
SGA Target Size (M) SGA Size Factor Est DB Time (s) Est Physical Reads
760 0.50 35,726,272 5,823,396,765
1,140 0.75 33,580,434 5,397,635,435
1,520 1.00 32,316,845 4,991,340,332
1,900 1.25 32,194,041 4,769,225,687
2,280 1.50 32,122,944 4,641,447,375
2,660 1.75 32,122,944 4,641,447,375
3,040 2.00 32,122,944 4,641,447,375
any inputs highly appreciated.