Listener and OS processes growth

[oisaya]

When a powerbuilder application users connect to the DB (8.1.6, AIX) we noticed that OS processes is created and hangs the system that no one can log in. DB is in a Dedicated Mode. When we shutdown the DB, the listener keeps creating OS processes and I expect an ORA error saying Oracle not available. We noticed sometime that we get about 300 OS processes created. Help

Osiaya

[arshiah]

I remember having a similar problem when we were using VB front-end at a clients site.
There were 100s of connections created by one program.
The developers had to change their code to release or drop the connection to the database after they were done with the query.
Hope this will give you some ideas :-)

[oisaya]

According to the developer, only 2 connections are made and they are opened for 7 minutes before disconnection. Is there a bug that no one has heard about? Thanks

Oisaya

[arshiah]

Are they using

Disconnect using SQLCA;

In the PB applications?

[mary]

Check with your junior developers first. They may need to issue disconnect transaction_object_name in their code. It is a common problem.