How to interpret advisories from awr reports
hi 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,
any inputs highly appreciated.
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.
2