OCP - Oracle Certified Professional

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

Tags: ASM, Automating Tasks with the Scheduler, Monitoring and Managing Memory, Monitoring and Managing Storage, pga, sga, sql, zarządzanie i monitorowanie pamięci, zarządzanie i monitorowanie storage, zarządzanie pamięcią oracle

This entry was posted on piątek, czerwiec 20th, 2008 at 23:27 and is filed under OCP. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.