shared pool and ORA-04031 - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: shared pool and ORA-04031

  1. #11
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    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

  2. #12
    Join Date
    Nov 2006
    Posts
    5
    Boris,
    Thanks. We cannot set cursor_sharing to force/similar because looks like it has some issues. And bugs. So at this point it would help if I can know if memory related to session_cached_cursors can be moved out or not or is it like PINNED/KEPT objects which cannot be moved out. Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width