Session Manager

This allows the user to use a web interface to see his own sessions and kill them

Setup

  • Go to pdb-backup1
   $ cd ~/production/session_manager
  • Run
   $ sqlplus "sys@<db_name> as sysdba" @sessions_sys
   $ sqlplus webinstance@<db_name> @sessions_webinstance
  • add a DAD in oraweb
    • file is /opt/home/oracle/product/ias1022/Apache/modplsql/cfg/wdbsvr.app
    • it should be like the following one
    • no need to restart the iAS from what I know
[DAD_edmsdb-training]
connect_string = edmsdb-training
reuse = Yes
enablesso = No
stateful = STATELESS_RESET
response_array_size = 128
bind_bucket_widths = 32,128,1450,2048,4000
bind_bucket_lengths = 4,20,100,400
;
  • ask Catherine if you need a link on the web site


This topic: PSSGroup > PhysicsDatabasesSection > DbaArea > SessionManager
Topic revision: r4 - 2005-11-29 - unknown
 
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