Name the ORACLE Background Process?
Answers were Sorted based on User's Feedback
Answer / shareef
there aretwo types of oracle background process
1.mandatory background process
DBWn,PMON,SMON,LGWR and CKPT
2.optional Background process
ARCn,CJQ0,LMS,Dnnn,Pnnnn,Snnn,LCKn,RECO etc.
Is This Answer Correct ? | 31 Yes | 3 No |
Answer / ravi dutta
pmon, smon, dbwr, lgwr, ckpt, arch, disp,cjq and more...
Is This Answer Correct ? | 21 Yes | 2 No |
Answer / avdhesh yadav
there are two types of oracle background process
1.mandatory background process given below :=
DBWn,PMON,SMON,LGWR and CKPT
2.optional Background process given below :=
ARCn,CJQ0,LMS,Dnnn,Pnnnn,Snnn,LCKn,RECO etc.
Is This Answer Correct ? | 14 Yes | 0 No |
What is the function of Dispatcher (Dnnn)?
What is the OPTIMAL parameter ?
How will you estimate the space required by a non-clustered tables?
What are the components of SGA?
What are Oracle Schema Objects?
What is meant by Redo Log file mirrorring ? How it can be achieved?
How will you force database to use particular rollback segment?
List the Optional Flexible Architecture (OFA) of Oracle database ?
What is hit ratio ?
What is the role of PCTFREE parameter is Storage clause ?
What is Dedicated Server Configuration?
What are the functions of SMON?