This forum is currently locked. You can't register or post questions at this time. (read more)

How to kill / terminate an Oracle Session

All posts relating to Oracle database administration.

Moderator: Tim...

ssadoglu
Senior Member
Posts: 61
Joined: Wed Feb 02, 2011 10:59 am

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,

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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

ssadoglu
Senior Member
Posts: 61
Joined: Wed Feb 02, 2011 10:59 am

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,

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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

ssadoglu
Senior Member
Posts: 61
Joined: Wed Feb 02, 2011 10:59 am

Re: How to kill / terminate an Oracle Session

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

OK. Thanks so much again. :)

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 6 guests

cron