Re: MMNL absent message in alert log

From: <fitzjarrell_at_cox.net>
Date: Thu, 13 Dec 2007 13:57:59 -0800 (PST)
Message-ID: <f9bdbecd-e9d1-4df5-9a5e-2d64f8433ced@d4g2000prg.googlegroups.com>

On Dec 13, 2:23 pm, eAddict <eAdd..._at_gmail.com> wrote:
> I have shut down SAP but can't even get in at an SQLplus prompt...
> There are 3 processes that
> are taking up A HUGE amount of resources.
>
> CPU TTY PID USERNAME PRI NI SIZE RES STATE TIME %WCPU %CPU
> COMMAND
> 0 ? 27589 orabpr 241 20 4053M 9536K run 111:29 100.09 99.92
> oracleBPR
> 4 ? 14547 orabpr 241 20 4049M 6720K run 102:27 99.77 99.60
> oracleBPR
> 1 ? 14451 orabpr 241 20 4071M 15760K run 282:38 99.67 99.49
> oracleBPR
>
> What happens if I just outright kill the processes? There are no
> users connected since SAP and the listener are down.

The processes die, and you then defer 'recovery' until startup. Normally.

David Fitzjarrell Received on Thu Dec 13 2007 - 15:57:59 CST