Re: Too many processes

In article <95tbqn$vcm$1_at_nnrp1.deja.com>,   jdorlon_at_my-deja.com wrote:
> 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
>

There are several factors which could affect the answer.

Are you running dedicated server connects or using MTS? Do you have pre-allocated server connections?

If you are not using MTS and do not have pre-allocated sessions then this would appear, to me, to be a definite problem that I would refer to support after checking the listerner log and looking for sqlnet.log files related to these processes.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com
http://www.deja.com/