Profile
e-Catalog
Contact
Search
Cart
|
Profile |
|
Contact |
Search |
Cart |
 |
Oracle8i Performance Tuning: Optimizing I/O |
| Course Status: | Released |
| Course Language: | English |
| Course Duration: | 4 Hours |
| Deployment Options: | Online, Interactive CDs, Network, Downloads, Intranet |
| Audience |
| Database administrators, network administrators |
| Prerequisites |
| Completion of the E&A Oracle Introduction, Oracle8i Database Administration, and Oracle8i Backup and Recovery Curricula |
| Course Aim |
| To discuss how to optimize I/O operations and manage space usage |
| Learning Objectives |
| Explain how to size and tune the redo log buffer. Explain how to distribute files and monitor I/O. Monitor and tune disk I/O by querying dynamic performance views. Describe how to manage extents and minimize block visits. Explain migration and chaining. Eliminate migrated rows. Explain how to reorganize indexes. |
| Topics Covered |
| The redo log buffer - Sizing the redo log buffer - Tuning and reducing redo Database design and I/O issues - Distributing files - Monitoring I/O - Hands-on: Querying dynamic performance views Optimizing space usage - Extent management - Minimizing block visits Reclaiming space - Migration and chaining - Hands-on: Eliminating migrated rows - Index reorganization |