Home/ Questions/Q 4022
In Process

vinish.ai Latest Questions

  • 0
  • 0
Asked: 2020-12-07T19:35:53+00:00

Schedule Job to logoff all logged users

  • 0
  • 0

Hi Vinish,

i am new in Oracle.

do you have a script for daily logging off all logged user in Oracle DB-Session? Can you help?

Thanks in advance

Kader

schedule jobscriptsql developer
Share
Leave an answer

Leave an answer

Browse

1 Answer

  1. To do this, I think you just need to kill all the active sessions. Try the below code:

    BEGIN
FOR r IN (select sid,serial# from v$session)
LOOP
EXECUTE IMMEDIATE 'alter system kill session ''' || r.sid || ',' 
|| r.serial# || ''' immediate';
END LOOP;
END;