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

1649

---

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2381

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

1854

---

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

1591

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1494

---

How do you tell what your machine name is and what is its IP address?

1500

---

How would you go about verifying the network name that the local_listener is currently using?

1598

---

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

1436

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

1892

---

What is the recommended interval at which to run statspack snapshots, and why?

2425

---

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?

1511

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1496

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1425

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4000

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

1423

---