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 |
How can you find the size of a database?
What is the role of PCTFREE parameter is Storage clause ?
What is PGA?
What does LGWR do?
List the factors that can affect the accuracy of the estimations ?
What is the functionality of SYSTEM table space ?
What is the function of ARCH?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
How will you create multiple rollback segments in a database ?
What is meant by free extent ?
When Does DBWR write to the database?
What are functions of PMON?