killing unused session

[alainc]

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

[nabaig]

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