Thanks. That clarifies things. Time to look into this some more.
mkb --- [EMAIL PROTECTED] wrote: > 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 > === 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).