Posts

Showing posts with the label sessions

View and terminate Oracle Database user sessions

View and terminate Oracle Database user sessions Verify sessions: SELECT USERNAME FROM V$SESSION; SELECT USERNAME, SID, SERIAL#, STATUS   FROM V$SESSION   WHERE USERNAME like SCOTT%; Generate SQL to terminate sessions: SELECT ALTER SYSTEM KILL SESSION || SID || , || SERIAL# || ;   FROM V$SESSION   WHERE USERNAME like SCOTT%; download  file  now
Read more