Oracle Database Administration/Performance
This lesson introduces Oracle database performance management.
Objectives and Skills
editObjectives and skills for the performance management portion of Oracle Database Administration I certification include:[1]
- Performance Management
- Use Automatic Memory Management
- Use Memory Advisors
- Troubleshoot invalid and unusable objects
Readings
editMultimedia
editActivities
editAutomatic Memory Management
edit- Use Enterprise Manager Database Control / Server / Memory Advisors to view and configure Automatic Memory Management.
- Disable Automatic Memory Management.
- View available SGA and PGA settings.
- Enable Automatic Memory Management.
Memory Advisors
edit- Use the following queries to view memory advisor values:
SELECT * FROM V$PGA_TARGET_ADVICE;
SELECT * FROM V$SGA_TARGET_ADVICE;
SELECT * FROM V$MEMORY_TARGET_ADVICE;
Invalid and Unusable Objects
edit- Use the following query to identify invalid objects:
SELECT OWNER, OBJECT_TYPE, OBJECT_NAME FROM DBA_OBJECTS WHERE STATUS = 'INVALID';
- Use the following query to identify unusable indexes:
SELECT OWNER, INDEX_NAME FROM DBA_INDEXES WHERE STATUS = 'UNUSABLE';
See Also
editReferences
edit