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.

Answer / ravi dutta

pmon, smon, dbwr, lgwr, ckpt, arch, disp,cjq and more...

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.

What is the maximum size of a row in oracle 9i?

4 Answers   Baidu, HCL, Yashu Systems,

---

1.Explain the three levels with the help og a diagram.

1 Answers   Baidu,

---

What is the maximum size of a oracle9i database?

1 Answers   Baidu, HCL, TCS,

---

How will you monitor the space allocation ?

3 Answers  

---

Which parameter in Storage clause will reduce no. of rows per block?

1 Answers  

---

How will you force database to use particular rollback segment?

1 Answers  

---

What is dictionary cache ?

2 Answers  

---

What is Cursor?

2 Answers   Virtusa,

---

What is a Multi-threaded Server Configuration?

1 Answers  

---

What is meant by recursive hints ?

1 Answers  

---

What is meant by Redo Log file mirrorring ? How it can be achieved?

1 Answers  

---

What are the two types of Server Configurations?

3 Answers  

---