Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SMON - Killed process

RE: SMON - Killed process

From: Singla, Sanjeev K. <>
Date: Wed, 5 Jul 2000 09:10:12 -0400
Message-Id: <>

Try getting the spid from v$process by joining v$process and v$session. Kill -9 spid at OS level. Most of the times it release the resources .


-----Original Message-----
From: Weerd de E.C. Kirsten [] Sent: Monday, July 03, 2000 4:04 AM
To: Multiple recipients of list ORACLE-L Subject: RE: SMON - Killed process

I tried a shutdown abort, startup and shutdown immediate. But believe it or not, SMON just got back at it as soon as I did a shutdown immediate ...

Anyway, I was advised by Orcale to put event = "10052 trace name context forever" in the init.ora file. I have no idea what it does, but I enabled us to shut down the database and take a complete backup. After that, we removed the event-line, started the database and did a shutdown immediate again ... SMON kept working at it for a couple of hours, but was finished by the time I got in this morning to make sure everybody could get to work. Just hope it goes well this evening.

> -----Original Message-----
> From: Chuck Hamilton []
> Sent: Friday, June 30, 2000 5:03 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: SMON - Killed process
> 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.

Author: Weerd de E.C. Kirsten

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: (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 Wed Jul 05 2000 - 08:10:12 CDT

Original text of this message