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
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 :-)