when you kill a session (alter system kill session) oracle rollsback the session and frees other rescource usage.
This can take a while to compleate. (day's)
Even if i kill the sub-process (or thread) on OS level, the session semains in the ORACLE data dictionary (as marked).
Oracle reconmands to restart the database, whoever this is not possible at this time.
How do i start PMON (or other utility) manually, to clear the zomby process, ie known on oracle level but not anymore on OS-level)?
Any advice is welcomed.
PMON is automatically started after an internal timeout.
Say No To Plastics
PMON is one of the 5 mandatory background processes to start when the database is started.
And it releases like you said the resourses.
However this is, a very nasty, and also happened to us here where this killed session remained in the v$session view.....
esp with the client session being inactive.
alter system kill session ',' immediate;
However here the instance reco will be done at db startup...
The best is also to let the user's try to execute a command and when he get's the message he must log off or make oracle log him off after a certain number of tries..
Tht way he's out of the dict. view eventually.
Atleast that's what worked for me......
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be
Click Here to Expand Forum to Full Width