5.361 DBA_SQL_QUARANTINE

DBA_SQL_QUARANTINE displays information about SQL Quarantine configurations.

Each row in this view represents a quarantine configuration for a SQL plan.

Column Datatype NULL Description

SIGNATURE

NUMBER

NOT NULL

Unique SQL identifier generated from normalized SQL text

NAME

VARCHAR2(128)

NOT NULL

Unique plan identifier in string form as a search key

SQL_TEXT

CLOB

NOT NULL

Un-normalized SQL text

PLAN_HASH_VALUE

NUMBER

Unique plan identifier in numeric form as a search key

CPU_TIME

VARCHAR2(4000)

CPU time threshold (in seconds)

IO_MEGABYTES

VARCHAR2(4000)

I/O threshold (in megabytes)

IO_REQUESTS

VARCHAR2(4000)

Physical I/O threshold (number of physical I/O requests)

ELAPSED_TIME

VARCHAR2(4000)

Elapsed time threshold (in seconds)

IO_LOGICAL

VARCHAR2(4000)

Logical I/O threshold (number of logical I/O requests)

CREATOR

VARCHAR2(128)

User who created the quarantine configuration

ORIGIN

VARCHAR2(16)

Method by which the quarantine configuration was created. The only possible value is RESOURCE-MANAGER, which indicates that the quarantine configuration was created by the Resource Manager.

DESCRIPTION

VARCHAR2(500)

Text description

CREATED

TIMESTAMP(6)

NOT NULL

Time at which the quarantine configuration was created

LAST_EXECUTED

TIMESTAMP(6)

Time at which the quarantine configuration was last used

ENABLED

VARCHAR2(3)

Indicates whether the quarantine configuration is enabled (YES) or disabled (NO)

AUTOPURGE

VARCHAR2(3)

Indicates whether the quarantine configuration is auto-purged (YES) or not (NO)

Note:

This view is available starting with Oracle Database release 19c, version 19.1.

See Also:

Oracle Database SQL Tuning Guide for more information about quarantined SQL plans