RE: SMON - Killed process

I'm no expert either, but you are out of luck either way. If Oracle needs to roll back that transaction, there is no "better" way to get rid of it. Even if you shutdown abort, on recovery it will still need to do that. Your best solution would be to find out who cretaed the job that was rolling back and make sure they don't do any significant job like that without intermittent commits.

Steve Monaghan
WorldCom

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Weerd de
> E.C. Kirsten
> Sent: Friday, June 30, 2000 8:08 AM
> To: Multiple recipients of list ORACLE-L
> Subject: SMON - Killed process
>
>
> Hi,
>
> We run Oracle 7.2.3 on HP-UX 10.20
>
> Each night, we run a script which kills running sessions, if any, on
> HP-level. After that an shutdown immediate is performed an backup starts.
> Everything worked fairly well.
>
> Last night, a hugh Oracle procedure was running and get killed by
> the script. However, about 8 hours later the immediate shutdown
> was not yet
> performed. As far as I could tell, it was waiting for the
> ORA_SMON process,
> which was running at 90% cpu. Is SMON cleaning up the killed procedure ???
>
> Best solution I figure would be killing the ORACLE-session, rather
> than killing the process on HP-level. Would that prevent events similar to
> last night ? But how to do it ???
>
> Any hints for this constantly learning - I only learned about Oracle
> about 2 years ago - they're all looking at me - junior would be grately
> appreciated, as ever !!!
>
> Greets,
>
>
> Kirsten
> Living : Near Antwerp - Belgium
> Working : Near Breda - Netherlands
>
> --
> Author: Weerd de E.C. Kirsten
> INET: Kirsten.deWeerd_at_Oranjewoud.nl
>
> 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 Jun 30 2000 - 09:41:44 CDT