Oracle 19c is finally out with some great features but sadly many of them are not available in Oracle Enterprise Edition
I started by looking at the SQL Quarantine feature in my last blog post and as stated it will not work if you are on Oracle EE. So what’s the next step ?
Here is some interesting stuffs that i discovered when playing around with one the new 19c feature known as SQL Quarantine. Beside controlling it the usual way such as using DBMS_SQLQ as explained in the documentation we can also use a special undocumented quarantine HINT.
What this core oracle function is about ? Here is a little script that we can use to extract further information about a specific oracle kernel function which might help us in that process (Beside the usual way , another tool in your toolbox 🙂 ).
Hatem Mahmoud's blog 