daemon connections
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: daemon connections

  1. #1
    Join Date
    Nov 2002

    daemon connections

    We discovered a bug in our system regarding our daemons running.
    We have a few daemons running for reporting, downloading etc....
    Now recently we saw that for some reason some daemons keep their connections to the DB open. We already debugged some of them but it seems we missed some. So what happens now is these daemons keep their old connections open while they create other connections. Thus not closing their old connections filling up the connections to the Oracle DB. Now a few weeks ago we got an error saying a daemon couldn't connect to the DB because the connection limit was reached. What I wanted to know now is, is there a script I can run to check which daemons are connecting, to what they are connecting, how long etc.... This way we can pinpoint the daemons keeping old connections open. Then we would be able to write a script that can be ran once in a while to close the old connections so they get freed up again.

    We are running Oracle 8.0.x on a Linux RedHat platform.

  2. #2
    Join Date
    Mar 2001
    Better to fix your bug.
    But you can query: select * from v$session;
    and will find all you need.
    Best wishes!

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