Tematy OCP część III
piątek, czerwiec 20th, 2008
Monitoring and Managing Storage - zarządzanie i monitorowanie storage
- Tune redo writing and archiving operations
- Issue statements that can be suspended upon encountering space condition errors
- Reduce space-related error conditions by proactively managing tablespace usage
- Reclaim wasted space from tables and indexes using the segment shrink functionality
- Estimate the size of new table and indexes
- Use different storage options to improve the performance of queries
- Rebuild indexes online
Automating Tasks with the Scheduler - ASM
- Set up initialization parameter files for ASM and database instances
- Execute SQL commands with ASM file names
- Start up and shut down ASM instances
- Administer ASM disk groups
- Use RMAN to migrate your database to ASM
Monitoring and Managing Memory - zarządzanie i monitorowanie pamięci
- Implement Automatic Shared Memory Management
- Manually configure SGA parameters for various memory components in the SGA
- Use Automatic PGA Memory Management