OraFAQ Forum: Server Administration » ORACLE 9i - Which Background Porcesses optional or Mandatory

Home » RDBMS Server » Server Administration » ORACLE 9i - Which Background Porcesses optional or Mandatory

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORACLE 9i - Which Background Porcesses optional or Mandatory [message #178181]

Tue, 20 June 2006 00:35

amit_nanote
Messages: 56
Registered: July 2005
Location: Indore

Member

Dear All,

This time I am coming up with the query related to the background processes.
Refering to ORACLE 9i
I Know that following processes are mandatory -
SMON
PMON
CKPT
LGWR
DBWR

Now i would like to know that apart from above mentioned process are there any processes which are mandatory? I am giving the list
1)ARCN - Optional (confirmed)
2)LMON - Is LMON?
3)LMDn - Is LMDn?
4)BSP0-BSP9 - ?
5)QMN0-QMN9 -?
6)EMN0/EMON - ?
7)RECO - optional but mandatory for the distributed database.
8)J000-J999 -?
9)Dnnn - Y this is optional parameter in its absence who take care for the dispatch the requests
10)Snnn -Y this is optional?
11)Pnnn -?
12)TRWR - I think tihs must be mandatory?
13)Innn-?
14)WMON - ?

Looking for your expert comments on the issue.
Regds
Amit

Report message to a moderator