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

Ever since I started working with Oracle, I had an interest in Oracle database performance tuning. This led, eventually, to a four day training I made and gave for customers of Transfer Solutions. Since 2012 I work for Rabobank Nederland. A few years ago I also became interested in Oracle database security. All technology aside, it is my experience that security usually plays out on a political level. I'm a Oracle certified professional for the 8i, 9i, 10g and 11g databases and Oracle Database 11g Performance Tuning Certified Expert.
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