DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: open_cursors query

Threaded View

  1. 06-01-2010, 09:29 AM #5
    mahajanakhil198
    mahajanakhil198 is offline Senior Member
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    Quote Originally Posted by PAVB View Post
    Please remember open_cursors defines max number of cursors EACH session can concurrently have - 65K private sql areas for a single session?

    Have you ever hit ORA-01000?

    If not, that means system is not even using as many cursors as current value of open_cursors is set.
    The customer faced the error ORA-01000. We recommended to increase the value to 2000 but he asked us what if he sets the maximum value. That's why, I just want to be sure.


    It's Windows 2003 Server here on target side and RHEL from source side.
    Last edited by mahajanakhil198; 06-01-2010 at 09:37 AM. Reason: added more information
    lucky
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width