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

2049

---

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

2008

---

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

2355

---

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

2920

---

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?

2075

---

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.

1947

---

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

1899

---

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

4523

---

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

1889

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2256

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1884

---

How would you begin to troubleshoot an ORA-3113 error?

2079

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1911

---

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2051

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2275

---