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

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

---

what do you understand by flashback feature of oracle?

1 Answers   Oracle,

---

what is the use of recording information about current session?

1 Answers   Oracle,

---

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

---

who owns the operating system files created by the utl_file package?

1 Answers   Oracle,

---

What view would you use to determine free space in a tablespace?

3 Answers  

---

any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,

---

What is the difference between Datapump & export/import?

2 Answers  

---

How do you open a cluster administrator? : sql server DBA

1 Answers  

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1 Answers  

---