Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: neverending raise of processes number
Yes of course, there are always 4 up to 8 oracle process, but our problem is
that only in that instance (ARUN) the number of internal processes still raises up to max_process ( 100 in that case ). On the other inctance (name:ATEST) on the same machine there are no problems, but we have to store
data in inctance with the name ARUN. Is it possible to rename ATEST to ARUN or move the all data files from ATEST to ARUN ?
Regards
Marcin
vijaylamba_at_my-deja.com wrote:
> hi,
> if your database is open and there are no external connections, you will
> still have some background processes on which is part of the oracle
> instance. for example DBWR,LGWR,PMON,SMON etc.
> So it is oracle that has started these processes and they should always
> be on to keep the database open.
> Regards
> Vijay
> In article <38479983.15FAAC94_at_gsg-berlin.com>,
> Marcin Wojcicki <wojcicki_at_gsg-berlin.com> wrote:
> > Hi,
> > my problem is that the number of oracle processes allways raise
> > (v$process) ( whithout any connection to DB - number of sessions stays
> > constant -v$sessions). Oracle is on NT machine that is connected to
> big
> > network. Does anyone have idea what could start these prcesses or how
> > can I find it out . I already tried to dump trace files but I don't
> > understand it. The part of it :
> >
> > PROCESS 28:
> > ----------------------------------------
> > SO: 7eb9d9c, type: 1, owner: 0, flag: INIT/-/-/0x00
> > (process) Oracle pid=28, calls cur/top: 0/7f027e4, flag: (0) -
> > int error: 0, call error: 0, sess error: 0, txn error 0
> > (post info) last post received: 0 0 0
> > last post received-location: No post
> > last process to post me: none
> > last post sent: 0 0 0
> > last post sent-location: No post
> > last process posted by me: none
> > (latch info) wait_event=0 bits=0
> > Process Group: DEFAULT, pseudo proc: 7ec7130
> > O/S info: user: SYSTEM, term: DDAAP131, ospid: 1561
> > OSD pid info: 1561
> > ----------------------------------------
> > SO: 7f6f0e4, type: 9, owner: 7eb9d9c, flag: INIT/-/-/0x00
> > (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 7eb9d9c,
> > event: 29, last message event: 29, messages
> read:
> > 0
> > channel: (7f70294) system events broadcast
> > channel
> > scope: 101, event: 55, last mesage
> > event: 0,
> > publishers/subscribers: 0/52,
> > messages published: 0
> > ----------------------------------------
> > SO: 7f027e4, type: 2, owner: 7eb9d9c, flag: INIT/-/-/0x00
> > (call) sess: cur 0, rec 0, usr 0; depth: 0
> >
> > Thanks
> > Marcin
> >
> >
>