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" <[EMAIL PROTECTED]> 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> <P><FONT SIZE=2 FACE="Arial">Hi!</FONT> </P> <P><FONT SIZE=2 FACE="Arial">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.</FONT></P> <P><FONT SIZE=2 FACE="Arial">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.</FONT></P> <P><FONT SIZE=2 FACE="Arial">Any idea what was going on? Why did it take so long? Was it all rollback activity?</FONT> </P> <P><FONT SIZE=2 FACE="Arial">This is 8.1.7 on sun Solaris.</FONT> </P> <P><FONT SIZE=2 FACE="Arial">Thanks,</FONT> <BR><FONT SIZE=2 FACE="Arial">Helmut</FONT> </P> <BR> </BODY> </HTML> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
