Oracle Database Discussions

Hi,

I have some confusion regarding the understanding of ADDM and AWR report.

I have created AWR reports for various period. All report indicated that all Instance efficiency checklists at their high 90s.

I have also created ADDM report during the same intervals. ADDM reports suggesting a higher SGA value.

When I am trying to correlate the ADDM and AWR then the findings seems self contradictory. On one hand AWR reflecting high instance efficiency ratios and on the other ADDM suggesting for higher SGA value. Please help me to get a better idea regarding this.

There is one more confusion. Due to some product related compulsion we have to use CURSOR_SHARING=EXACT. But the AWR report reflects 98 against Soft Parse %. Though we are using high number of bind variable within our application. But due to the value of CURSOR_SHARING all queries should be hard parsed each time the literal change. As per my understanding there should be very less soft parsing, but the value reflects high Soft Parse.

Thanks in advance for your valuable time.

Regards,
Joy