5.359 DBA_SQL_QUARANTINE
DBA_SQL_QUARANTINE
displays information about quarantine configurations.
Each row in this view represents a quarantine configuration for a SQL plan.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique SQL identifier generated from normalized SQL text |
|
|
|
Unique plan identifier in string form as a search key |
|
|
|
Un-normalized SQL text |
|
|
|
Unique plan identifier in numeric form as a search key |
|
|
|
CPU time threshold (in seconds) |
|
|
|
I/O threshold (in megabytes) |
|
|
|
Physical I/O threshold (number of physical I/O requests) |
|
|
|
Elapsed time threshold (in seconds) |
|
|
|
Logical I/O threshold (number of logical I/O requests) |
|
|
|
User who created the quarantine configuration |
|
|
|
Method by which the quarantine configuration was created. The only possible value is |
|
|
|
Text description |
|
|
|
Time at which the quarantine configuration was created |
|
|
|
Time at which the quarantine configuration was last used |
|
|
|
Indicates whether the quarantine configuration is enabled ( |
|
|
|
Indicates whether the quarantine configuration is auto-purged ( |
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