killing unused session
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: killing unused session

  1. #1
    Join Date
    Jan 2001
    Posts
    44

    Question

    hi,

    i have a problem with sessions.
    i have at least 10 automatic processes connected to a 8.0.4 db if th client pc (where the processes are) restart the linked sessions on the server didn't stop so after few reboot i reach the max connections and get errors!

    how to solve it?

    thanks

  2. #2
    Join Date
    Aug 2000
    Posts
    236
    If what you re telling us is that even after the client is shut down the server sessions still remain open in Oracle, then the application code of the client has to be rewritten to log off from oracle gracefully.

    To kill unwanted sessions;

    use:

    alter system kill session 'SID, SERIAL#';

    whise values you can get from v$session.

    Nizar

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