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

3778

---

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

2477

---

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?

1999

---

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

3226

---

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

4443

---

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

2565

---

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?

2700

---

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.

2170

---

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

2424

---

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

2727

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

2377

---

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

2061

---

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

1919

---

How would you extract DDL of a table without using a GUI tool?

2502

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2059

---