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

622

---

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?

648

---

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

692

---

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

601

---

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

683

---

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.

623

---

Can you remove an open file under unix?

724

---

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

601

---

When should you increase copy latches?

672

---

How to uncatalog backup?

600

---

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?

1230

---

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

545

---

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

598

---

How to drop an oracle database?

599

---

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?

624

---