Talking about bind variables, you can consider setting the cursor_sharing parameter to similar or force. That should immediately substitute where possible the constants with bind variables.
See metalink Note:94036.1 for details
Good luck
Boris
|
Results 1 to 10 of 12
Thread: shared pool and ORA-04031Threaded View
|
Click Here to Expand Forum to Full Width |