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.
As i’m playing with an exadata binary on my local machine, i need to set the parameter “_exadata_feature_on”=true to get SQL QUARANTINE feature to work (As Rodrigo Jorge already pointed out).
When analyzing the package ” dbms_sqlq_internal” i spotted something interesting
We are building a HINT here named “QUARANTINE” which can take this parameters :
We can also extract the specified hint using a similar query on SYS.SQLOBJ$ and SYS.SQLOBJ$DATA tables :
And here is a quick test using a special value in this case “ALWAYS_QUARANTINE” :
Ex : 1
Ex 2 :
That’s it 😀