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
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sat Dec 04 1999 - 06:38:46 CST
