Tuning Questions
1. A tablespace has a table with 30 extents in it. Is this bad?
Why or why not.
Level:
Intermediate
Expected answer:
Multiple extents in and of themselves aren?t bad. However if you also have
chained rows this can hurt performance.
2. How do you set up tablespaces during an Oracle installation?
Level: Low
Expected answer: You
should always attempt to use the Oracle Flexible Architecture standard or
another partitioning scheme to ensure proper separation of SYSTEM, ROLLBACK,
REDO LOG, DATA, TEMPORARY and INDEX segments.
3. You see multiple fragments in the SYSTEM tablespace, what
should you check first?
Level: Low
Expected answer:
Ensure that users don?t have the SYSTEM tablespace as their TEMPORARY or
DEFAULT tablespace assignment by checking the DBA_USERS view.
4. 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.
