Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?

310

---

Discuss row chaining, how does it happen? How can you reduce it?

294

---

Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?

272

---

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

276

---

You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?

495

---

While taking hot backup (begin end backup) what will happens back end?

288

---

You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

305

---

If you are not sure what command does a particular unix function what is the best way to determine the command?

287

---

If you see contention for library caches how you can fix it?

297

---

How can you determine if the sqlnet process is running for sqlnet v1? How about v2?

283

---

You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?

267

---

What are some indications that you need to increase the shared_pool_size parameter?

284

---

When should you increase copy latches? What parameters control copy latches?

299

---

How should a many-to-many relationship be handled?

294

---

If you see statistics that deal with "undo" what are they really talking about?

392

---