Re: get the sid,serial# of my connection?

On Dec 24, 3:42�am, m..._at_pixar.com wrote:
> Michel Cadot <micadot{at}altern{dot}org> wrote:
> > "Mark D Powell" <Mark.Pow..._at_eds.com> a ?crit dans le message de news:
> >> Hey, I learned something new. �thanks Laurenz.
> > So do I
>
> Thanks all... here's my results which are working great.
>
> 1. a shell script to kill a connection:
>
> � � � � #!/bin/sh
> � � � � # kill a specified oracle session
>
> � � � � sid=$1; ser=$2; inst=$3
> � � � � echo -n sys password:
> � � � � stty -echo; read pass; stty echo
> � � � � echo "alter system kill session '$sid,$ser';"|
> � � � � � � �sqlplus -SL sys/$pass@$inst as sysdba
>
> 2. a local function (this in python) to generate a call to this script.
> � �I call this at the beginning of my test program and print the
> � �string so I can cut and paste.
>
> � � � � def killstring(curs):
> � � � � � � """return a string that will kill this db connection"""
> � � � � � � curs.execute("""SELECT dbms_debug_jdwp.current_session_id,
> � � � � � � � � � � � � � � � � � �dbms_debug_jdwp.current_session_serial,
> � � � � � � � � � � � � � � � � � �sys_context('USERENV', 'INSTANCE_NAME')
> � � � � � � � � � � � � � � FROM dual""")
> � � � � � � (sid,serial,instance)=curs.fetchone()
> � � � � � � s="oracle-killsession %s %s %s"%(sid,serial,instance)
> � � � � � � return s
>
> 3. and a sample invocation
>
> � � � � ohm ~/tst$ oracle-killsession 98 45809 tmpltest2
> � � � � sys password:
> � � � � System altered.
>
> 4. and from my client... hooray!!!
>
> � � � � cx_Oracle.DatabaseError: ORA-00028: your session has been killed
>
> Share and enjoy!
> Mark
>
> --
> Mark Harrison
> Pixar Animation Studios

Why not have the routine issue the kill via execute immediate rather than have to cut and paste?

HTH -- Mark D Powell -- Received on Wed Dec 24 2008 - 10:40:25 CST