Skip to content

Commit 8d2625c

Browse files
committed
spm fix
1 parent fdedc62 commit 8d2625c

File tree

1 file changed

+10
-0
lines changed

1 file changed

+10
-0
lines changed

optimizer/spm_fix/README.md

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -14,6 +14,7 @@ It works as follows:
1414
- The good plan is tested (automatically) by SPM and a SQL plan baseline is created
1515
- Q1 now uses the good plan
1616

17+
```
1718
$ sqlplus / as sysdba [or connect to PDB ADMIN]
1819
SQL> @@user
1920
SQL> connect spmdemo/spmdemo
@@ -25,7 +26,16 @@ SQL> @@tab
2526
-- Review/execute the following script
2627
--
2728
SQL> @@example
29+
```
2830

2931
Note that AWR is accessed. Check the Oracle Database License Guide for details.
3032

3133
The test creates two tables T1 and T2 - use a test database
34+
35+
DISCLAIMER:
36+
<br/>-- These scripts are provided for educational purposes only.
37+
<br/>-- They are NOT supported by Oracle World Wide Technical Support.
38+
<br/>-- The scripts have been tested and they appear to work as intended.
39+
<br/>-- You should always run scripts on a test instance.
40+
41+

0 commit comments

Comments
 (0)