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

507

---

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

480

---

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?

551

---

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?

750

---

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

524

---

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

558

---

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

515

---

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

517

---

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

516

---

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

493

---

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

518

---

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

527

---

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

502

---

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

610

---

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

612

---