Re: processes not released, got ora-00020 error

v$process also includes oracle background processes, but their number is usually under 15 (unless you're using MTS).

I would search Metalink for dead-connection-detection.

or this newsgroup for expire_time, or something like that

All those oracle<sid> are dedicated connection processes.

On 5 Nov 2001 13:36:07 -0800, gary.yu_at_istark.com (Gary YU) wrote:

>Hi experts,
>
>I got some problem with the oracle processes recently, all new
>connection request through TNS are rejected(ora-00020 error). I
>checked my init<sid>.ora file, the 'process' parameter was 200, so I
>doubled it to 400. But I soon ran into the same problem 2 days after.
>
>I checked v$process, there're 397 processes running, and I checked
>v$session, there're 40-50 sessions. It seemed that some process are
>not exit/released, I also checked in the Unix command line(HP UX
>11.0), ' ps -ef|grep oracle', there are more than 400 process named
>'oraclebvprod'(bvprod is my SID) like this:
>
>oracle 23784 1 0 20:58:51 ? 0:00 oraclebvprod
>(DESCRIPTION=(LOCAL =no)(ADDRESS=(PROTOCOL=BEQ))
>
>we are running BroadVision web-server and eGate(a middle ware) as
>oracle client.
>
>my question is: should the count in v$process matches the count in
>v$session, and what reason may cause the process keep growing. Also
>what are these 'oracle<sid>' processes, and is there a safe way to
>manully release these process without re-bounce the oracle server.
>
>Thanks a lot!

.......
We use Oracle 8.1.6-8.1.7 on Solaris 2.6, 2.7 boxes

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email