Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

---

what is meant by gateway

1 Answers   IBM,

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

---

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

---

what is ora 600?

1 Answers  

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  

---