spauto.sql

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 »

How to Fix Broken Statspack Snapshot Jobs

by Ed Chen
December 30, 2016May 30, 2022

Saw a broken statspack snapshot job stopped working for several days. I tried to run the job on the spot but it still failed. So… Read More »