Name the ORACLE Background Process?
- 3 Answers
- 13660 Views
- I also Faced
- E-Mail Answers
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 does LGWR do?
What is an Oracle Rollback Segment?
Why query fails sometimes ?
What is an Integrity Constrains in Oracle?
What is meant by redo log buffer ?
How the log writer writes the data into database
How to find the current session sid
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
What are the functions of SMON?
what is the role of archiever
What is the function of ARCH?
What is dictionary cache ?
Oracle General 
