STATSPACK

How to Resolve ORA-20200: Database Instance does not exist

by Ed Chen
July 11, 2022July 12, 2022

ORA-20200 When we ran a STATSPACK report, we got error ORA-20200. SQL> @?/rdbms/admin/spreport.sql ... ORA-20200: Database/Instance 356760607/1 does not exist in STATS$DATABASE_INSTANCE ORA-06512: at line… Read More »

AWR Report for Standard Edition?

by Ed Chen
April 28, 2018May 17, 2023

AWR for Standard Edition I was assigned to collect some performance data in an unfamiliar database. While I ran AWR report by executing @?/rdbms/admin/awrrpt.sql under… Read More »

How to Fix Broken Statspack Snapshot Jobs

by Ed Chen
December 30, 2016May 17, 2023
2 Comments

Broken STATSPACK After we create and initiate STATSPACK in Oracle database, we sometimes might see a broken STATSPACK snapshot job stopped working for several days.… Read More »

JavaScript is not enabled. Please enable it and reload the page.