Re: Too many processes

From: ledz <ian_ledzion_at_urbanet.ch>
Date: Sun, 11 Feb 2001 20:42:25 +0100
Message-ID: <966pql$mc4$1@news1.urbanet.ch>

It could be that the extra rows are sessions which ended abnormally on the client, and which PMON did not pick up as being dead. I know of a situation where there were 1000's of dead sessions because the users shut down their machines without closing the DB sessions.

<jdorlon_at_my-deja.com> wrote in message news:95tbqn$vcm$1_at_nnrp1.deja.com...
> sorry for the crosspost, I got no response on this in comp.databases.
> oracle.server.
>
>
> In my 8.1.6.2 database running on AIX, I have about 500 rows in
> v$process, but only about 10 in v$session. The extras seem to be
> listener processes which aren't dying.
>
> has anyone seen this before? shouldn't PMON kill these processes off?
> is there a way to make PMON wake up and do its job?
>
> thanks
>
> -John
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Sun Feb 11 2001 - 13:42:25 CST