1Z0-030 Oracle9i: New Features for Administrators Practice Exam

Demo Question 1.

You and several other DBAs are discussing the different areas in the SGA and debating the importance of tuning each area. The four statements below are made during your conversation. Which two are true? (Choose two.)

A. When you tune the shared pool, you should concentrate on tuning the data dictionary cache. If the hit ratio for the data dictionary cache is acceptable, the hit ratio for the library cache should also be acceptable.
B. A cache miss in the database buffer cache is more expensive that a miss in the data dictionary cache or the library cache, so tuning the database buffer cache is a priority.
C. A cache miss in the data dictionary cache or the library cache is more expensive than a miss on the database buffer cache, so tuning the shared pool is a priority.
D. When using shared servers, you should either allocate additional space to the shared pool or set up the large pool to accommodate the User Global Area for the shared server users.


Display Answer

Answer: C, D

Explanation: