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

542

---

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

526

---

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?

610

---

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?

794

---

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

559

---

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

590

---

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

565

---

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

564

---

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

570

---

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

541

---

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

560

---

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

570

---

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

558

---

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

653

---

When should the default values for oracle initialization parameters be used as is?

672

---