Originally posted by efrijters
Lately we had some huge problems with the clients network. Terminal Services crashed sometimes, ISA servers crashed, cpu-fans burned out, virus attacks were encountered. It was a real party, last few weeks...

Any idea why PMON doesn't do his clean up?
PMON will not delete the session object until the connected OS session realises it's been killed, once an Oracle session is killed the session is marked and PMON starts it's cleanup of resources.

The Oracle session remains until the client attempts another request at which point it gets the killed notification and then PMON can remove the session from v$session.

Therefore is the client session never makes that additional call (i.e it has hung or is defunct) the session will remain.

HTH