Why are recursive relationships bad? How do you resolve them?

532

---

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

565

---

When configuring sqlnet on the client what files need to be set up?

582

---

A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?

514

---

How can you determine the space left in a file system?

586

---

You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.

542

---

Can you remove an open file under unix?

645

---

How can you determine if an oracle instance is up from the operating system level?

518

---

When should you increase copy latches?

584

---

How to uncatalog backup?

504

---

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

1153

---

What causes the "snapshot too old" error? How can this be prevented or mitigated?

475

---

How many redo logs should you have and how should they be configured for maximum recoverability?

522

---

How to drop an oracle database?

505

---

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?

545

---