sqlperf_noawr.sql for the Diagnosics Pack impaired

So you want to do SQL performance investigations, but your Oracle database is Standard Edition or you have no Diagnostics Pack. These things happen. In fact, at my previous job only 2 out of 70 customers did have Diagnostics Pack. Let’s say I got to know Statspack a lot better. Or free tools like ASHviewer (which is pretty neat).

So because there are probably many DBA’s that don’t have access to Diagnostics Pack, I’ve created sqlperf_noawr.sql. It’s sqlperf.sql without selects on dba_hist_% views, executes on dbms_xplan.display_awr or selects on statistics history in sys.wri$_% tables (even though I think it isn’t counted as usage of the Diagnostics Pack in dba_feature_usage_statistics).


About Marcel-Jan Krijgsman

Marcel-Jan is de PR-functionaris van de Werkgroep Maan en Planeten. Hij verzorgt ook het nieuws op de Facebook pagina en deze blog.
This entry was posted in Oracle performance tuning, Oracle scripts. Bookmark the permalink.

5 Responses to sqlperf_noawr.sql for the Diagnosics Pack impaired

  1. Pingback: Version 1.3 of sql_sql_id_html.sql and a new script: stats_sql_id_html.sql | Marcel-Jan's Oracle Blog

  2. Pingback: sql_sql_id_html.sql version 1.4 | Marcel-Jan's Oracle Blog

  3. Pingback: sql_sql_id_html.sql is now called sqlperf.sql (and new versions too) | Marcel-Jan's Oracle Blog

  4. Pingback: sql_sql_id_html.sql version 1.2 is out | Marcel-Jan's Oracle Blog

  5. Pingback: sql_sql_id_html.sql: a SQL performance script with HTML output | Marcel-Jan's Oracle Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s