Check Whether Connection Pooling is On?

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

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,

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?

The exact error msg is -
ORA-00020: maximum number of processes (300) exceeded