Re: SMON - Killed process

--0-846930886-962376080=:671
Content-Type: text/plain; charset=us-ascii

 It's rolling back the transactions for the killed sessions. 8 hours seems like an awfully long time though. I sometimes wonder if SMON gets lost. In that situation I would probably abort the instance followed by a restart and see if the rollback completes any faster during automatic recovery. I know of several DBAs who make that their standard practice before starting a cold backup - abort, restart, shutdown immediate.

  "Weerd de E.C. Kirsten" <Kirsten.deWeerd_at_Oranjewoud.nl> wrote: 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).


---------------------------------
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
--0-846930886-962376080=:671
Content-Type: text/html; charset=us-ascii



<P> It's rolling back the transactions for the killed sessions. 8 hours seems like an awfully long time though. I sometimes wonder if SMON gets lost. In that situation I would probably abort the instance followed by a restart and see if the rollback completes any faster during automatic recovery. I know of several DBAs who make that their standard practice before starting a cold backup - abort, restart, shutdown immediate.<BR>

<P>&nbsp; <B><I>"Weerd de E.C. Kirsten" &lt;Kirsten.deWeerd_at_Oranjewoud.nl&gt;</I></B> wrote: <BR>

<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">Hi,<BR><BR>We run Oracle 7.2.3 on HP-UX 10.20<BR><BR>Each night, we run a script which kills running sessions, if any, on<BR>HP-level. After that an shutdown immediate is performed an backup starts.<BR>Everything worked fairly well.<BR><BR>Last night, a hugh Oracle procedure was running and get killed by<BR>the script. However, about 8 hours later the immediate shutdown was not yet<BR>performed. As far as I could tell, it was waiting for the ORA_SMON process,<BR>which was running at 90% cpu. Is SMON cleaning up the killed procedure ???<BR><BR>Best solution I figure would be killing the ORACLE-session, rather<BR>than killing the process on HP-level. Would that prevent events similar to<BR>last night ? But how to do it ???<BR><BR>Any hints for this constantly learning - I only learned about Oracle<BR>about 2 years ago - they're all looking at me - junior would be grately<BR>appreciated, as ev!

er !!!<BR><BR>Greets,<BR><BR><BR>Kirsten<BR>Living : Near Antwerp - Belgium<BR>Working : Near Breda - Netherlands<BR><BR>-- <BR>Author: Weerd de E.C. Kirsten<BR>INET: Kirsten.deWeerd_at_Oranjewoud.nl<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br>
Get Yahoo! Mail - Free email you can access from anywhere!