Sniped sessions automatic killing

• This script creates a job that automatically checks and kills all sniped sessions (sessions that timed out, but were not cleaned properly) on all the instances
• Job, by default, runs every full hour on all the instances

Installation

• connect to pdb-backup
• make sure that the user pdb_admin exists and has quota on a tablespace (ex: data01)

   $ cd ~/production/sniped_sessions
   $ sqlplus sys@<db_name> as sysdba @kill_sniped_sessions

• please ignore the error of dropping non-existing table

Enabling/Disabling

• connect to the target database
• to disable or enable kill jobs please execute one of the following commands:

   exec PDB_ADMIN.KILL_SNIPED_SESSIONS_DISABLE();

   exec PDB_ADMIN.KILL_SNIPED_SESSIONS_ENABLE();