Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

---

How many packages we have in db

1 Answers   Tesco,

---

---

Explain the difference between a data block, an extent and a segment.

2 Answers  

---

one datafile is lost in standy side how can you recover that??

2 Answers  

---

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

2 Answers   Satyam,

---

what is ora 600?

1 Answers  

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

---

Explain materialized views and how they are used.

0 Answers  

---