We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
There was an error while loading. Please reload this page.
1 parent e6a7759 commit 51570eeCopy full SHA for 51570ee
optimizer/creative_w_plan/spm_prof/disablep.sql
@@ -1,3 +1,7 @@
1
+--
2
+-- Disable all SQL Profiles where the SQL statement
3
+-- is able to use a SQL plan baseline instead.
4
5
begin
6
for rec in (select sql_profile
7
from v$sqlarea
optimizer/creative_w_plan/spm_prof/makeb.sql
+-- Make a SQL plan baseline for any SQL statement
+-- in the cursor cache that has an active SQL profile.
declare
ret varchar2(100);
0 commit comments