AWR – SQL Statistics

Oracle: 12.1.0.1

Probably most of you have access to AWR report or have your own scripts to find TOP SQL statements in your database.

But if you don’t and you don’t have access to dbms_workload_repository and you don’t have permission to run awrrpt.sql script and you don’t like Enterprise Manager (yuck)  or you just want to add some information to existing AWR report (e.g. plan_hash_value ), you should read this article 🙂
Continue reading “AWR – SQL Statistics”