Answer / sudarsan

check point is a background process(chk process name),when
ever any transaction takes place oracle create an check
point for that particular transaction and that is saved
into the controlfile header as well as datafile header.

Answer / sreeramch9

Check Point(CKPT) is a Background Processor, which update latest SCN to datafile header and control file by using online redolog file.

Answer / kittu_chintu2005

A checkpoint is a mandatory background process which signals to DBWn

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

Datapump backup steps?

1 Answers  

---

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

Name three advisory statistics you can collect.

1 Answers  

---

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

How would you extract DDL of a table without using a GUI tool?

0 Answers  

---

What happens on checkpoint? : sql server DBA

0 Answers  

---

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

---

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---