RE: SMON - Killed process

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 .

Sanjeev

-----Original Message-----
From: Weerd de E.C. Kirsten [mailto:Kirsten.deWeerd_at_oranjewoud.nl] 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 [SMTP:chuck_hamilton_at_yahoo.com]
> 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
  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).