I want to know what users are connected.
Printable View
I want to know what users are connected.
check v$session view
Why have i many recordset in this table
How to delete all ghosts sessions ???
those arent ghost sessions, those are background processes which keep Oracle functioning, there should be around 8 or 9
If you really see ghost sessions you have to do alter sytem kill