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?

543

---

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

505

---

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

478

---

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?

549

---

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?

747

---

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

522

---

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

557

---

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

513

---

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

514

---

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

514

---

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

490

---

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

515

---

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

525

---

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

499

---

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

604

---