RE: RESOURCES ARE NOT FREED WHEN A SESSION DIES ABNORMALLY.
Date: Fri, 1 Aug 2008 14:15:19 -0400
Message-ID: <0684DA55864E404F8AD2E2EBDFD557DA01792398@JAXMSG01.crowley.com>
Yes I agree, I never had issues with alter system kill session on
windows (2 years). orakill was for orphaned threads in unusual
situations, 4031's etc. perhaps needed it once or twice and it really
turned out not to be much of a help in that situation as it kill the
symptoms and not the cause.
I have killed plenty a session. One should try to communicate however to the DBA that they would like their session killed rather than they 'X' out of their session as that stands a better chance of killing the os process/thread at the same time - as opposed to killing the session after the 'user' did not exit properly for whatever reason.
Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Baumgartel, Paul
Sent: Friday, August 01, 2008 1:42 PM
To: freelist freelist
Subject: RE: RESOURCES ARE NOT FREED WHEN A SESSION DIES ABNORMALLY.
I worked on Windows database servers for a couple of years. You can use "alter system kill session". The purpose of orakill is to provide a way to kill the underlying Oracle process thread if "alter system" doesn't work--in this way it's analogous to "kill -9 <oracle session PID> on Unix/Linux. Remember, on Windows, Oracle sessions are threads, not individual processes.
Paul Baumgartel
CREDIT SUISSE
Information Technology
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Powell, Mark D
Sent: Friday, August 01, 2008 1:28 PM
To: freelist freelist
Subject: RE: RESOURCES ARE NOT FREED WHEN A SESSION DIES ABNORMALLY.
Joe, If the database is on Windows then yes I would use orakill rather than ALTER SYSTEM. Being that I do not normally run Oracle on Windows I do not know if the official recommendation has changed but it was to use orakill instead of ALTER SYSTEM when the utility was first introduced. I am not sure from the OP if the database is on Windows also or just the client was on Windows.
- Mark D Powell --
Phone (313) 592-5148
Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 01 2008 - 13:15:19 CDT