0 Replies Latest reply on Mar 26, 2008 2:48 PM by Sean Berry

    Stupid Database Tricks

    Sean Berry

      How to find existing sessions in an Oracle DB:

       

      SELECT s.sid,

      s.serial#,

      s.username,

      s.osuser,

      s.program,

      s.status

      FROM v$session s;

       

       

      How to kill them:

       

      alter system kill session 'SID,SERIAL#';