Answer / shwetha

During normal running of database, dirty buffers are added
to checkpoint queue.Also when a block is first modified it
is entered in the checkpoint queue.The RBA of redo record
is also added.Every 3 sec CKPT records the RBA from
checkpoint queue.In case of instance failure RBA gives the
location from where recovery has to start( Checkpoint
position). During log switch CKPT updates contrl file and
data file headers.

How do you resize a data file?

2 Answers  

---

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

---

what are the types of connection load-balancing?

0 Answers   Oracle,

---

Explain the use of table functions.

1 Answers  

---

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---

what is meant by gateway

1 Answers   IBM,

---

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

---

What is dcl? : sql server DBA

0 Answers  

---

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

---

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

---

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---