How to kill / terminate an Oracle Session

All posts relating to Oracle database administration.

Moderator: Tim...

How to kill / terminate an Oracle Session

Postby ssadoglu » Tue Apr 30, 2013 10:17 pm

Hi again ,

I would like to kill the long running sessions. So Is there any shell script which can be used by the developers to kill there sessions? Please explain me.


Kind Regards,
ssadoglu
Senior Member
 
Posts: 58
Joined: Wed Feb 02, 2011 10:59 am

Re: How to kill / terminate an Oracle Session

Postby Tim... » Wed May 01, 2013 7:26 am

Hi.

These are the methods for killing sessions:

http://www.oracle-base.com/articles/mis ... ssions.php

If they kill the wrong session they can completely crash the database, which is why it is very rare people give developers the ability to kill sessions.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17950
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: How to kill / terminate an Oracle Session

Postby ssadoglu » Wed May 01, 2013 7:51 am

Thank you very much. I'm just wondering that how to write shell script?

Kind Regards,
ssadoglu
Senior Member
 
Posts: 58
Joined: Wed Feb 02, 2011 10:59 am

Re: How to kill / terminate an Oracle Session

Postby Tim... » Wed May 01, 2013 9:24 am

Hi.

You should not be initiating the process using the OS. Your first action should be to attempt to kill the session using ALTER SYSTEM KILL ..., or ALTER SYSTEM DISCONNECT... Only is that fails should you consider an OS kill.

As said before, handing this responsibility over to developers is a mistake.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17950
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: How to kill / terminate an Oracle Session

Postby ssadoglu » Wed May 01, 2013 2:13 pm

OK. Thanks so much again. :)
ssadoglu
Senior Member
 
Posts: 58
Joined: Wed Feb 02, 2011 10:59 am

Re: How to kill / terminate an Oracle Session

Postby Tim... » Wed May 01, 2013 2:31 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17950
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 1 guest