Home » SQL & PL/SQL » SQL & PL/SQL » Impact on killing session (Oracle 9i,Windows 2000)
Impact on killing session [message #359203] Fri, 14 November 2008 02:17 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

hi all,

i have a question regarding killing a session.

Refresh activity was running for a long time as it is suppose to get finish soon.so,i have decided to kill that session using 'alter system kill session' .Can i use task manager to kill that session where refresh was running?if yes, what could be the impact?

Can anybody revert me with the answer?

Regards,
Balaji
Re: Impact on killing session [message #359208 is a reply to message #359203] Fri, 14 November 2008 02:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When you kill a session its current transaction is rolled back.

Regards
Michel
Re: Impact on killing session [message #359253 is a reply to message #359208] Fri, 14 November 2008 06:56 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

it didnot get u what you are saying .Please be clear.
Re: Impact on killing session [message #359254 is a reply to message #359253] Fri, 14 November 2008 07:02 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
balaji1482 wrote on Fri, 14 November 2008 12:56
it didnot get u what you are saying .Please be clear.

How many times have you been asked NOT to use IM speak (such as u instead of you) Why do you insist on insulting posters by continuing to ignore these requests?
What bit don't you understand? The meaning of "Rolled back" or the meaning of "Current transaction"

[Updated on: Fri, 14 November 2008 07:03]

Report message to a moderator

Re: Impact on killing session [message #359255 is a reply to message #359203] Fri, 14 November 2008 07:02 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Can i use task manager to kill that session where refresh was running?

No. You can only kill top level processes using Task Manager.
If you download Process Explorer from MS, this allows you to terminate individual threads. You will need to find the OS Process from v$process in order to terminate the correct thread.

Just connect to SQL*Plus as a DBA account and issue the Alter System command.

Alternatively, as you say you don't understand what Michel says about the impact of killing a session , you might want to get your DBA to do this for you.

Why do you think the session needs to be killed? What is it waiting on (check v$session_waits for the SID in question)
Re: Impact on killing session [message #359256 is a reply to message #359255] Fri, 14 November 2008 07:10 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

If you have the privilige , use the orakill utility

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

H:\>orakill

Usage:  orakill sid thread

  where sid    = the Oracle instance to target
        thread = the thread id of the thread to kill

  The thread id should be retrieved from the spid column of a query such as:

        select spid, osuser, s.program from
        v$process p, v$session s where p.addr=s.paddr

H:\>
Re: Impact on killing session [message #359365 is a reply to message #359208] Sat, 15 November 2008 04:29 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member



Hi michel,

Can you please explain me about this 'When you kill a session its current transaction is rolled back' with some examples.

Its a kind request.

Regards,
Balaji
Re: Impact on killing session [message #359376 is a reply to message #359365] Sat, 15 November 2008 09:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't understand what example are you expecting.
Explain your question.

Regards
Michel
Re: Impact on killing session [message #359431 is a reply to message #359376] Sun, 16 November 2008 02:19 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

hi,

I asked you a question regarding an impact on killing an oracle session using windows task manager, u replied

'When we kill a session its current transaction is rolled back' .

what does it mean ? please explain it.

Regards,
Balaji

Re: Impact on killing session [message #359432 is a reply to message #359431] Sun, 16 November 2008 02:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This means the current work is undone.

Regards
Michel

[Updated on: Sun, 16 November 2008 02:25]

Report message to a moderator

Re: Impact on killing session [message #359435 is a reply to message #359432] Sun, 16 November 2008 02:52 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Thanks michel and other oracle experts who has helped me with the answers.

[Updated on: Sun, 16 November 2008 02:52]

Report message to a moderator

Previous Topic: select statement help
Next Topic: Please help me with sqlplus reporting command
Goto Forum:
  


Current Time: Thu Dec 08 12:40:29 CST 2016

Total time taken to generate the page: 0.08466 seconds