Profile
e-Catalog
Contact
Search
Cart
|
Profile |
|
Contact |
Search |
Cart |
 |
Oracle8i Performance Tuning: Measuring Performance |
| 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 introduce the student to the tools and mechanisms used to gather the information used to tune the database and its environment |
| Learning Objectives |
| Outline tuning goals. Discuss the steps involved in the tuning process. Use alert and trace files. Identify the performance views used to gather tuning information. Use utlbstat and utlestat. Explain latch types and wait events. Describe the Oracle tools used to diagnose performance problems. |
| Topics Covered |
| Locating diagnostic information - The tuning process - Alert and trace files - Dictionary and special views Gathering statistics - Using utlbstat and utlestat - Latches and wait events - The event management system Tuning tools - Oracle Diagnostics Pack - The TopSessions utility - Oracle Tuning Pack |