Listener and OS processes growth
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Listener and OS processes growth

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    42
    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

  2. #2
    Join Date
    Dec 2000
    Posts
    43
    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 :-)

  3. #3
    Join Date
    Oct 2000
    Posts
    42
    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

  4. #4
    Join Date
    Dec 2000
    Posts
    43
    Are they using

    Disconnect using SQLCA;

    In the PB applications?

  5. #5
    Join Date
    Aug 2000
    Posts
    163
    Check with your junior developers first. They may need to issue disconnect transaction_object_name in their code. It is a common problem.


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