Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ADDM Findings Top SQL Statements

User_Z3XA6Apr 23 2015 — edited Apr 30 2015

Hi,

I have run addmrpt.sql for 1 month of time using snapshots and every ADDM report says that sql statement having id **** listed under top sql statements findings and recommendation is to tune using sql tunning advisor. It has 2-4 seconds elapsed time.But when i go through AWR report instance efficiency report and all are normal.

Can anyone please confirm whether I should recommend to tune this SQL statement to my vendor ?

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on May 28 2015

Added on Apr 23 2015

#general-database-discussions

17 comments

3,120 views