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 will you swap objects into a different table space for an existing database?
How the log writer writes the data into database
What is SGA?
How to define Data Block size in Oracle?
What are the components of SGA?
What is an Oracle SYSTEM tablespace and when is it Created?
What is the use of Oracle Control File?
What constitute an ORACLE Instance?
1.Explain the three levels with the help og a diagram.
What is Shared Pool?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What is meant by Redo Log file mirrorring ? How it can be achieved?