Oracle 11g. The devs leave sessions connected overnight, sometimes certain cron jobs fail because of that. I am trying to kill all user sessions, but I can't.
I login as:
sqlplus system/[password] as sysdba
I do this to list the sessions:
select sid,serial#,program from gv$session where type='USER' and machine!='this-server';
And the list looks like this:
SID SERIAL# PROGRAM
10 7883 toad.exe 11 42365 toad.exe 77 22493 toad.exe
Then I do:
alter system disconnect session '10,7883' immediate;
And is says:
But nothing happens. The session is still there. What am I doing wrong?
P.S.: I'm pretty new to Oracle, I only used MySQL before.