Skip to content

Commit 51570ee

Browse files
committed
comments added
1 parent e6a7759 commit 51570ee

File tree

2 files changed

+8
-0
lines changed

2 files changed

+8
-0
lines changed

optimizer/creative_w_plan/spm_prof/disablep.sql

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -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+
--
15
begin
26
for rec in (select sql_profile
37
from v$sqlarea

optimizer/creative_w_plan/spm_prof/makeb.sql

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,7 @@
1+
--
2+
-- Make a SQL plan baseline for any SQL statement
3+
-- in the cursor cache that has an active SQL profile.
4+
--
15
declare
26
ret varchar2(100);
37
begin

0 commit comments

Comments
 (0)