ASH and AWR Deep Dive

Kellyn Pot'vin
Oracle

[Author note: showed up on-time, and it was standing room only!]

Blocking sessions are SO slow in nearly every Enterprise Manager instance. Use the command-line. AWR will

ASH will tell you activity over time

ADDM Compare will run two ASH reports and the difference between the two.

• Clear description of impact of change
• what you need to do address the issue
• identifies causes behind the change
• list regressed SQL
• NOTE: EM12c should use preferred credentials

SQL Monitor

• Developers should have access to SQL Monitor
• See differences in duration easily within the tool
• You can see FULL detail for SQL Execution
• plan stats
• other goodies
• and view a Report of SQL Monitor for stuff
• CLI available DMBS_SQLTUNE.REPORT_SQL_MONITOR

One of the Best & Least Used Features in EM

• Search SQL!
• Choose AWR snapshots, AWR Baselines and SQL_ID
• or where SQL 'like' something

AWR and ASH from the CLI -- ALL DBAs should know how to do this!

awrsqlrpt.sql --

[Author note: SLIDES have all the details. I'll post scripts later. Battery almost dead. ]