19C Database Upgrade and Impact to OTM/GTM Cloud
As part of the migration to 19C database there is a new feature we have questions on:
SQL statements that are terminated by Oracle Database Resource Manager due to their excessive consumption of CPU and I/O resources are automatically quarantined. The execution plans associated with the terminated SQL statements are quarantined to prevent them from being executed again.
This feature protects an Oracle Database from performance degradation by preventing execution of SQL statements that excessively consume CPU and I/O resources.
Looking to determine what the potential impact of this change might be and will our SQL's be quarantined.