Skip to content

Commit 57d86d1

Browse files
committed
outlines
1 parent e681b7b commit 57d86d1

File tree

3 files changed

+593
-4
lines changed

3 files changed

+593
-4
lines changed

optimizer/spm_plan_control/SE/README.md

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -4,15 +4,15 @@ Based on <a href="https://blogs.oracle.com/optimizer/using-sql-plan-management-t
44

55
The example_se.sql calls "proc_se.sql" (proc_se.sql is essentially the same as ../proc2.sql)
66

7-
Scripts create utility procedure called "add_my_plan" (see proc_se.sql) that allows you to take a SQL execution plan from a test query and apply it to an application query.
7+
Scripts create utility procedures called "set_my_plan" and "add_my_plan" (see proc_se.sql) that allows you to take a SQL execution plan from a test query and apply it to an application query.
88

9-
Example output is shown in example_se.lst.
9+
Example output is shown in example.lst.
1010

1111
Note that example_se.sql creates a new user called SPM_TESTU.
1212

13-
Scripts tested in Oracle Database 18c Standard Edition
13+
See also example_outln.sql for an example of how to migrate a stored outline
1414

15-
There is an outstanding parsing issue with SE - see directory 27500184
15+
Scripts tested in Oracle Database 18c Standard Edition
1616

1717
DISCLAIMER:
1818
<br/>-- These scripts are provided for educational purposes only.

0 commit comments

Comments
 (0)