If you see the value for reloads is high in the

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

(Continued from previous question...)

If you see the value for reloads is high in the estat library cache report is this a matter for concern?

Level: Intermediate
Expected answer: Yes, you should strive for zero reloads if possible. If you see excessive reloads then increase the size of the shared pool.

(Continued on next question...)

Other Job Interview Questions

• What is the diff. when confine mode is on and when it is off?
• How will you force database to use particular rollback segment?
• What is the difference between OLE Server & OLE Container?
• When do you use data parameter type?
• What is a Schema?
• What are the steps involved in Database Startup?
• What is the main diff. bet. Reports 2.0 & Reports 2.5?
• What is the User-Named Editor?
• What does ROLLBACK do?
• Give the stages of instance startup to a usable state where normal users may access it.
• More...