You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: optimizer/fine_grained/README.md
+4-2Lines changed: 4 additions & 2 deletions
Original file line number
Diff line number
Diff line change
@@ -2,11 +2,13 @@ This directory contains examples of fine-grained cursor invalidation.
2
2
3
3
The 'tests.sql' script is provided to give you ideas on how to try this feature out for yourself. There is a spool file tests.lst if you want to look at expected output.
4
4
5
-
The tests are in a raw state because I originally wrote the examples for my own benefit to explore the boundaries of this feature. In particular, there is a mixture of some DDL that *will* allow SQL statements to use rolling invalidation and some DDL that will not. Some of the PROMPT comments may be incorrect now because the test was created before Oracle Database 12c R2 was released.
5
+
The tests are in a raw state because I originally wrote the examples for my own benefit to explore the boundaries of this feature. In particular, there is a mixture of some DDL that *will* allow SQL statements to use rolling invalidation and some DDL that will not. There may be cases where a statement is accepted but it results in a no-op. Some of the PROMPT comments may be out of date because the test was created before Oracle Database 12c R2 was released.
6
+
7
+
My intention is to tidy up these scripts for Oracle Database 18c but I hope you will find them interesting now.
6
8
7
9
### Note
8
10
9
-
The example here was run on Oracle Database 12c Release 2.
11
+
The example was run on Oracle Database 12c Release 2.
10
12
11
13
The tests are not intended to be 'full coverage' - there may be other cases that work.
0 commit comments