Re: Runaway SMON process

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Wed, 12 Dec 2001 19:22:32 -0800
Message-ID: <bpnbv9.t8l.ln@zstux.ita.pwr.wroc.pl>

Have you checked your alert log and trace files? These are the first things you need to check whenever you have some problems. Look those files and check if there are anything written about these?

The other thing is check the V$system_event view to find what SMON process is waiting for. Get th SID of SMON and find out for what it is waiting.

Best Regards,
K Gopalakrishnan

"Osbit" <kpage_at_osbit.com> wrote in message news:1008156702.6462.0.nnrp-02.3e31dc83_at_news.demon.co.uk...
> I'm having a problem with the SMON process on my Oracle instance. It has
> suddenly become the busiest process on the system, consuming about 50% CPU
> on a system that is doing nothing else at all. Disk activity is at almost
> zero, only writing about 2.4Kb / sec to three data areas.
> If I try and shutdown the database it just hangs there, so I tried a
> shutdown abort and then a restart with the same result, a hang.
> I can't figure out what the SMON process is doing as I've not worked with
> Oracle for that long.
>
> Can anyone help out the new guy ?
>
> Thanks in advance.
>
>
Received on Wed Dec 12 2001 - 21:22:32 CST