When working in Optimizer, I can optimize without any problems and alternatives are given, but if I try to execute them in any way in Optimizer (the original SQL or the alternatives) it notes PLS-00215: String length constraints must be in range (1 .. 32767) error.
No run time stats are given to compare with.
Steps to replicate:
-------------------
1. Connect to 11G database
2. Open Optimize SQL tab
3. Enter a sql
4. Execute (can test with original, no need to optimize)
5. Above error given in status column
Both original and alternative SQL are valid and can be executed outside of Optimizer.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center