try 'kill -l' where the -l is an ell as in -list. Jared
mkb <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/16/2002 11:41 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: How do I check whether a rollback activity is going on I was wondering where a list of kill signals (kill -1, kill -9 etc) can be found. I've always used kill -9 but I'd rather try something less drastic first, even though I've never run into problems using kill -9 pid before. man pages don't seem to list the signals (Solaris 7). thanks mkb (hmmm....can you say mutating thread...) --- [EMAIL PROTECTED] wrote: > Because 'kill' and 'kill -15' don't seem to work > consistently. > > kill -9 says 'kill with extreme prejudice, take no > prisoners!', whereas > your garden variety kill allows a process to call > for a priest, eat a last > meal and smoke a cigarette, all of which take too > much time. > > Jared > > > > > > "BALA,PRAKASH (Non-HP-USA,ex1)" > <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 07/16/2002 09:23 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject: RE: How do I check whether a > rollback activity is going on > > > Jared, I always kill the Oracle session first. So > could you elaborate why > you use 'kill -9'. > > TIA > Prakash > > -----Original Message----- > Sent: Monday, July 15, 2002 8:38 PM > To: Multiple recipients of list ORACLE-L > > > It could be that pmon is rolling back the > transaction. > > It could also be that pmon is never going to clean > it up, which sometimes > happens when killing an active transaction. > > I am a strong advocate of using 'orakill' on > NT/Win2k and 'kill -9' on > Unix to kill the process, rather than killing the > session in Oracle. > > If your session has still not been cleaned up, > you'll understand my > position, as you will now have to bounce your > database. > > Check to see if the session is holding a lock, if > so, and an unreasonable > amount of time has passed for pmon to do its > cleanup, then you likely > need to bounce the database. > > Jared > > > > > > > Gurelei <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 07/15/2002 02:39 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > cc: > Subject: How do I check whether a > rollback activity is > going > on > > > Hi. > > Here is my situation. I have killed an ORacle > transaction. Oracle came back with "session marked > for > kill" and the status of the session is now "Killed". > I presume that the reason is that Oracle needs to > roll > back the changes made. Can I confirm whether this is > indeed the case via some system tables? > > thakns > > gene > > __________________________________________________ > Do You Yahoo!? > Yahoo! Autos - Get free new car price quotes > http://autos.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Gurelei > 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). > > > > -- > 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). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: BALA,PRAKASH (Non-HP-USA,ex1) > 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). > > > > -- > 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). === message truncated === __________________________________________________ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb 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). -- 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).