Re:session marked for kill

From: <dgoulet_at_vicr.com>
Date: Fri, 09 Nov 2001 08:21:08 -0800
Message-ID: <F001.003C0EBF.20011109080120@fatcity.com>

Rollback is one definite possibility, so is the Duhveloper shutting down the process on his/her client machine. In either case, finding the process id and killing that process at the Unix level will also release stuff a lot faster.

Dick Goulet

____________________Reply Separator____________________
Author: "Daiminger; Helmut" <Helmut.Daiminger_at_KirchGruppe.de>
Date:       11/9/2001 1:45 AM

Hi!

I got a call from one of our developers and was told that his app was hung on the dev box. So I issued an "alter system kill session" command. It took about 30 seconds then I got the message: session marked for kill.

But the connection still showed up in v$session, even after 5 minutes it was still there. Then I decided to shut down the db (which was ok since he was the only developer on the box): immediate didn't work (i.e. it took about 3 mins and nothing happened), so I issued a shutdown abort and restarted the instance.

Any idea what was going on? Why did it take so long? Was it all rollback activity?

This is 8.1.7 on sun Solaris.

Thanks,
Helmut

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>session marked for kill</TITLE>
</HEAD>
<BODY>

Hi!


I got a call from one of our developers and was
told that his app was hung on the dev box. So I issued an "alter system kill session" command. It took about 30 seconds then I got the message: session marked for kill.

But the connection still showed up in v$session,
even after 5 minutes it was still there. Then I decided to shut down the db (which was ok since he was the only developer on the box): immediate didn't work (i.e. it took about 3 mins and nothing happened), so I issued a shutdown abort and restarted the instance.

Any idea what was going on? Why did it take so
long? Was it all rollback activity?


This is 8.1.7 on sun Solaris.


Thanks,
 Helmut

 

</BODY>
</HTML>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Nov 09 2001 - 10:21:08 CST