|
Provided by: 123-CBT Computer Based Training Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention |
 |
Course Overview
This course is the third in a three-part Oracle8i Performance Tuning series. This interactive course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student will use Oracle tools to diagnose and resolve contention, given the possible causes of contention. Finally, the participants will be introduced to the features of Oracle Expert, create a tuning session, gather, view and edit the input data, analyze the collected data using rules, review tuning recommendations and implement tuning recommendations.
Learn To:
- Determine the appropriate data block size.
- Optimize space usage within blocks.
- Detect and resolve row migration.
- Monitor and tune indexes.
- Recognize, diagnose, and resolve performance problems associated with sorts.
- Recognize, diagnose, and resolve performance problems associated with rollback segments.
- Define levels of locking and list the possible causes of contention.
- Use Oracle utilities to detect and resolve lock contention.
- Prevent locking problems and recognize errors arising from deadlock.
- Gather data and tune a database using Oracle Expert.
Content Emphasis
Skills-Based
Audience
Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course, and Oracle8i Performance Tuning: Strategies and Techniques (63331) and Oracle8i Performance Tuning: Managing Memory and Disk I/O (63332). This course will help candidates prepare for the Oracle8i Certified Database Administrator (DBA) Track Exam 4, 1Z0-024.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Using Oracle Data Blocks Efficiently
Duration: 1.5 - 2 Hour(s)- Match the component of database storage with its definition.
- Avoid dynamic allocation of extents by using the ALTER TABLE command.
- Avoid the dynamic allocation disadvantages by creating a locally managed tablespace.
- Select the advantages of incorporating large extents into the database design.
- Identify the characteristics of the Oracle block size.
- Identify the advantages and disadvantages of small data block and large data block sizes.
- Identify the functions of the PCTFREE and PCTUSED parameters.
- Identify the guidelines for setting the PCTFREE parameter.
- Calculate and set the PCTFREE parameter when creating a table.
- Identify the guidelines for setting the PCTUSED parameter.
- Calculate and set the PCTUSED parameter when creating a table.
- Identify the characteristics of row migration and chaining.
- Query a table to detect chained and migrated rows by using the ANALYZE TABLE command.
- Remove the chained and migrated rows from a given table by using a four-step procedure.
- Reclaim the space from the high water mark by using an ALTER TABLE command.
- Query the results of an ANALYZE command to evaluate Oracle data block usage.
- Monitor the space used for an index by using the ANALYZE INDEX command.
- Rebuild an index without writing the redo log entries by using the ALTER INDEX command.
Unit 2: Optimizing Sort Operations
Duration: 1.5 - 2 Hour(s)- Identify the operations that cause a sort.
- Sequence the steps in the sort process.
- Set the SORT_AREA_SIZE parameter by using the ALTER SESSION command.
- Identify the tuning s
This is primarily online training 
This is an online eLearning or CBT training program 
This program may be available on CD 
Contact 123-CBT Computer Based Training for more information Training Presented in: English
