WARNING: This web is not used anymore. Please use PDBService.KillingSnipedSessions instead!
 

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();

Topic attachments
I Attachment History Action Size Date Who Comment
Unknown file formatsql kill_sniped_sessions.sql r1 manage 2.1 K 2008-01-15 - 11:55 DawidWojcik Automatic Sniped Sessions killing script
Edit | Attach | Watch | Print version | History: r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r3 - 2008-01-15 - DawidWojcik
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback