Tag: AWR data mining

Pro-active AWR Data Mining to find change in SQL Execution Plan

Many times we have been called for the poor performance of a database and it has been narrowed down to a  SQL statement. Subsequent analysis have shown that the execution plan has been changed and a wrong execution plan was being…

Read More >

Mining the AWR to Identify Performance Trends

Sometimes it’s useful to check how performance of a SQL statement changes over time. The diagnostic pack features provide some really useful information to answer these questions. The data is there, but it not always easy to retrieve it, especially if…

Read More >

Trying Out S-ASH: Historical Performance Data for the Under-Licensed

I was recently playing with an Oracle XE database. The main benefit of Oracle XE is that it can be used free of charge.

Read More >