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

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

Installing and Configuring Statspack

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 […]

Convert a Physical Standby Database into a Snaphot Standby Database Using Oracle Enterprise Manager 11gR1 Grid Control

Oracle Database 11g introduced the Snapshot Standby feature in Data Guard. Using this feature you can use your physical standby database to temporary process transactions. If you have a need to test out application fixes […]

Convert a Physical Standby Database into a Snapshot Standby Database Using the Data Guard Command Line Interface

This document will detail the steps to convert a physical standby database to a snapshot database using the Data Guard Command Line Interface. If you would like to know more about snapshot databases or how […]

Convert a Physical Standby Database into a Snapshot Standby Database

Oracle Database 11g introduced the Snapshot Standby feature in Data Guard. Using this feature you can use your physical standby database to temporary process transactions. If you have a need to test out application fixes […]