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

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

0 Answers  

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers  

---

What column differentiates the V$ views to the GV$ views and how?

3 Answers  

---

how will you see when the database was started using sql prompt?

2 Answers   IBM,

---

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

What would you do with an "in-doubt" distributed transaction?

0 Answers  

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  

---

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

what is the use of recording information about current session?

0 Answers   Oracle,

---