Hi all,
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.