Name the ORACLE Background Process?
- 3 Answers
- 12908 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 |
Can a Tablespace hold objects from different Schemes in Oracle?
What is Cursor?
When does LGWR write to the database?
How will you swap objects into a different table space for an existing database?
What is User Process?
What is meant by free extent ?
What is meant by recursive hints ?
What is use of Rollback Segments In Database ?
List the factors that can affect the accuracy of the estimations ?
What is the role of PCTFREE parameter is Storage clause ?
What is Shared Pool?
How will you monitor rollback segment status ?
Oracle General 
