If you see a pin hit ratio of less than 0.8 in t

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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?

Level: Intermediate
Expected answer: This indicate that the shared pool may be too small. Increase the shared pool size.

(Continued on next question...)

Other Job Interview Questions

• Talk about “Exception Handling” in PL/SQL?
• What is hot backup and how it can be taken?
• What is a Segment?
• Explain the relationship among Database, Tablespace and Data file.?
• You have a rollback segment in a version 7.2 database that has expanded beyond optimal, how can it be restored to optimal?
• Define Transaction?
• What are the default extensions of the files created by library module?
• Give two examples of how you might determine the structure of the table DEPT.
• What is the purpose of the product order option in the column property sheet?
• What are the different modes of mounting a Database with the Parallel Server?
• More...