ORA-20200: Database/Instance does not exist in STATS$DATABASE_INSTANCE

by Eric Jenkinson on August 13, 2010 Tagged: , ,

When attempting to run a Statspack instance report using spreport.sql the following error is generated.
Read more »

Installing and Configuring Statspack

by Eric Jenkinson on August 12, 2010 Tagged: ,

With the addition of the Active Workload Repository (AWR) and Active Session History (ASH) in Oracle Database 10g and higher it might seem a little odd to still be talking about Statspack. Both AWR and ASH require an Oracle Diagnostics Pack license which is limited to the Enterprise Edition of the database.
Read more »