Answer / guest

ORACLE_BASE is the root directory for oracle. ORACLE_HOME
located beneath the ORACLE_BASE and is the place oracle
products reside.



Regards
Abhinav Phadnis

Answer / subu

exactly

Answer / shiva

$ORACLE_BASE: TOP OF ORACLE DIRECTORY
eg: u01/app/oracle
$ORACLE_HOME : WHERE THE ORACLE IS INSTALLED IN OUR SYSTEM
eg: $ORACLE_BASE/PRODUCT/RELEASED_VERSION

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

---

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

---

How can we see the database version in os level

6 Answers   Oracle,

---

what is logical system in sap basis

0 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

how can you enable flashback feature?

0 Answers   Oracle,

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---

Why would you use sql agent? : sql server DBA

0 Answers  

---

what are the benefits of flashback feature?

0 Answers   Oracle,

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

---

Hot backup procedure?

2 Answers  

---