Re: Awakening PMON to do its job

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Fri, 16 Feb 2007 09:59:16 +0100
Message-ID: <486b2b610702160059m6839ad4chebf2d919bed5333e@mail.gmail.com>

You could try

SQL> oradebug
help

<snip>
...

WAKEUP         <orapid>                  Wake up Oracle process

...
<snip>

ORADEBUG WAKEUP <oracle pid of pmon>

Stefan

On 2/15/07, cnewtonne_at_gmail.com <cnewtonne_at_gmail.com> wrote:
>
> We had an issue affecting one of our production DBs. The middle tier
> application for some reason, went crazy spawning processes chewing up
> the DBs process parameter. DB started throwing errors indicating max
> process exceeded. When I got to the database, I retrieved some of the
> SPIDs and all did not have client PIDs. At this point, we only option
> was to bounce the DB which ended up resolving the issue of cleaning up
> all these process.
>
> My question is could've we awakened the PMON process to do its cleaning
> and how? I know there is away using oradebug but I have not tried it
> first on any of my play databases to do in this production DB?
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 16 2007 - 02:59:16 CST