Check Whether Connection Pooling is On?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Check Whether Connection Pooling is On?

  1. #1
    Join Date
    May 2003
    Posts
    49

    Max Processes Exceeded!

    Hello,

    I have a DB, which periodically locks up because the maximum number of processes has been exceeded. I have a VB6.0 app utilising ADO and DSN-Less connections, with a maximum of 11 instances, which make thousands of connections a day. Within the application a connection is created within a class when the class is initialized and then closed on termination, which is usually once per day.

    This problem started when the DB was moved to a new server.

    I don't know whether this is the problem of not but can anyone tell me how to check -
    Whether connection pooling is enabled for an oracle DB and what the time out is set to?

    How do I ensure my Oracle DB is using connection pooling?

    Any help, advice or pointers will be greatly appreciated.

    Cheers Al
    Last edited by Running Bear; 11-20-2003 at 11:13 AM.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Woah there tiger. Connection pooling is either done at the middle tier or via a connection manager.

    If you are getting an error message about maximum number of processes exceeded, you probably have the processes parameter in your init.ora too low.

    Are you running MTS?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    May 2003
    Posts
    49
    Jeff,

    Hi, thanks for your relpy. Apologies I jumped off the deep end a bit there, I'm floundering!

    No, not running MTS.

    The processes in init.ora was initially set to 100, have changed it to 300 with no effect.

    Should I be using a connection manager, if so which would you recommend?

  4. #4
    Join Date
    May 2003
    Posts
    49
    The exact error msg is -
    ORA-00020: maximum number of processes (300) exceeded

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