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
Results 11 to 12 of 12
Thread: shared pool and ORA-04031
Click Here to Expand Forum to Full Width