Oralce 8.1.6 is running on a Sun Solaris 220R box.
The maximum number of processes is set to 200, yet a few days after running this limit is reached.
Doing a ps list or a top listing shows over 200 processes, and they almost all look like dead oracle connections.
The v$session table only shows about 25 connections.
The v$process table shows all 200 but not much more information than that.
What I need to know is what caused these 200 dead connections?
v$session has the information I want (MACHINE, TERMINAL, PROGRAM) but it only has that info on current connections. The dead ones don't show up there.
They must have been in v$session at one point, but that point has passed.
I was thinking maybe have oracle automatically copy anything that enters into v$session into another table where they won't be removed, so that I'll have sort of a transaction log. But I have no idea how to set up 'triggers' do this sort of thing.