Re: Oracle runnig too many processes ?

No, this is perfectly normal
you need to have
dbwr
lgwr
arch
smon
pmon
ckpt
reco
This is the absolute minimum to get it running at all

On top of that you have currently three connections open.

There must be other things going on.
Did you run utlbstat/utlestat?

Hth,

--
Sybrand Bakker, Oracle DBA
<orib_at_galileo.co.il> wrote in message
news:386B2034.57A3CA6E_at_galileo.co.il...
>
> Hi All.
> Do you know how many Oracle processes should run per DB ?
> cause my server is running slow lately , and I saw many processes
> running under it.
> I monitored the processes on my machine (Sun solaris , oracle 8.1.5 )
> and found more then one process
> per DB.
>
> here it is :
>
> oracle 9982 4.9 14.17810435352 ? R Nov 25 4497:25
> ora_ckpt_gtdb
> oracle 9976 0.0 14.17760835448 ? S Nov 25 0:14
> ora_pmon_gtdb
> oracle 9978 0.0 14.17838435392 ? S Nov 25 0:37
> ora_dbw0_gtdb
> oracle 9980 0.0 14.17812035304 ? S Nov 25 0:40
> ora_lgwr_gtdb
> oracle 9984 0.0 14.57708036360 ? S Nov 25 6:53
> ora_smon_gtdb
> oracle 9986 0.0 14.27700835640 ? S Nov 25 0:01
> ora_reco_gtdb
> oracle 9988 0.0 14.07708035192 ? S Nov 25 0:00
> ora_arc0_gtdb
> oracle 23446 0.0 14.37735235864 ? S 17:06:12 0:01 oraclegtdb
> (LOCAL=NO)
> oracle 24695 0.0 14.37760036024 ? S 18:56:52 0:01 oraclegtdb
> (LOCAL=NO)
> oracle 24697 0.0 14.27704035760 ? S 18:56:54 0:00 oraclegtdb
> (LOCAL=NO)
>
> Do I run too much processes ?
> Can I avoid running some of them ?
>
> Thanks
>
> Ori
>
>
>
Received on Thu Dec 30 1999 - 04:09:01 CST