OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)

14 Performance Management

CERTIFICATION OBJECTIVES

14.01 Use Automatic Memory Management

14.02 Use Memory Advisors

14.03 Troubleshoot Invalid and Unusable Objects

Two-Minute Drill

Self Test

Memory usage in an Oracle instance is critical for performance. If the amount of memory allocated to the various structures is not optimal, performance may degrade dramatically: the amount of memory should neither be too little, nor too much. With earlier releases of the database, tuning memory usage required a great deal of skill and time on the part of the ...