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.

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---

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

1 Answers   TCS,

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

internal architecture

0 Answers   CSC,

---

what is a crs resource?

0 Answers   Oracle,

---

What command would you use to create a backup control file?

2 Answers  

---

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

---