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?

587

---

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

540

---

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

523

---

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?

604

---

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?

789

---

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

555

---

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

588

---

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

563

---

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

560

---

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

563

---

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

539

---

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

553

---

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

568

---

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

547

---

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

645

---