7.7.4.10 CREATE QUARANTINE

Purpose

The CREATE QUARANTINE command allows a quarantine to be created manually.

Syntax

CREATE QUARANTINE quarantineType=value quarantinePlan="SYSTEM", 
                  dbUniqueName=value[, attributename=value]... 

Usage Notes

Manual creation of quarantines should be done in coordination with Oracle Support Services. In general, manual quarantines are created to proactively isolate SQL statements that are known to cause problems.

• quarantineType specifies the type of quarantine to be created, such as SQLID and SQL_PLAN.

• quarantinePlan must be set to SYSTEM. Oracle Support Services may specify other values.

• dbUniqueName specifies the name of the database that has the quarantine.

Example 7-89 Creating a Quarantine

This example shows the CREATE command with the QUARANTINE object.

CellCLI> CREATE QUARANTINE  DBUG comment='For debugging quarantines"

CellCLI> CREATE QUARANTINE quarantineType="SQLID", quarantinePlan="SYSTEM", -
         dbUniqueName="DB1", sqlid="5xnjp4cutc1s7";