V$SQL - SQL Quarantine

The following columns of the V$SQL and GV$SQL views show the quarantine information of execution plans of SQL statements:

* SQL_QUARANTINE - This column shows the name of the quarantine configuration for an execution plan of a SQL statement.
* AVOIDED_EXECUTIONS - This column shows the number of times an execution plan of a SQL statement was prevented from running after it was quarantined.

For more details see v$sql

Published 1st April 2022

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License