Impact on killing session [message #359203] |
Fri, 14 November 2008 02:17  |
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 #359254 is a reply to message #359253] |
Fri, 14 November 2008 07:02   |
pablolee
Messages: 2882 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   |
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)
|
|
|
|
|
|
|
|
|