What are some indications that you need to incre

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

(Continued from previous question...)

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

Level: Intermediate
Expected answer: Poor data dictionary or library cache hit ratios, getting error ORA-04031. Another indication is steadily decreasing performance with all other tuning parameters the same.

(Continued on next question...)

Other Job Interview Questions

• What is hot backup and how it can be taken?
• How would you determine who has added a row to a table?
• Display the number value in Words
• What is a Redo Log?
• What is pop list?
• What is the use of Control File?
• How can a button be used in a report to give a drill down facility?
• What is difference between CHAR and VARCHAR2?
• How can you enable automatic archiving?
• How can you enable automatic archiving?
• More...