Training Classes | Learning and Development Resources | Training Directory | New Training Seminars | New Training Providers | Site Map | Promote Training Seminars | Training Keywords | Training Seminars | Training Providers | Regions | Training Search | Advertise Training Seminars | Login
Provided by: Serebra Learning Corporation

Oracle8i Performance Tuning: Optimizing Sorts and Minimizing Contention

Click here for more information or to take this course 		Serebra Learning Corporation
  home  : Computer  : Oracle  : Perfomance Tuning
Get More Information
Search for Training
Find Your Genius!
What do you want to learn about?

Training Provided by Serebra Learning Corporation

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.

Training Avaliability and Delivery

This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Serebra Learning Corporation for more information
Schedule:8 hours
Training Presented in:English
Related Keywords:  oracle8i performance tuning 

Training Program Details

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.

Objective

  • 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.

Topics Include

Unit 1: Using Oracle Data Blocks Efficiently

  • 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

  • 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 sort goals.
  • Select the actions that avoid unnecessary sorts.
  • Query the V$SYSSTAT view and display the memory disk and row sort values.
  • Display the ratio of disk sorts to memory sorts using V$SYSSTAT.
  • Create a temporary tablespace using the CREATE TABLESPACE command.
  • Identify the methods that can be used to configure temporary tablespaces.
  • Query the number of extents and the maximum number of blocks for sorts using V$SORT_SEGMENT.
  • Join the V$SESSION and V$SORT_USAGE views to obtain information on currently active disk sorts.

Unit 3: Tuning Rollback Segments

  • Match the uses of rollback segments with their definitions.
  • Select the characteristics of rollback segment activity.
  • Identify the characteristics of rollback segment growth.
  • Match the transaction-level type with its definition.
  • Identify the goals of tuning rollback segments.
  • Match the dynamic view name with its content.
  • Diagnose rollback segment header contention by using the V$ROLLSTAT view.
  • Diagnose rollback segment contention by using the V$WAITSTAT and V$SYSSTAT views.
  • Assign a rollback segment to a transaction by using the SET TRANSACTION command.
  • Select the guidelines for sizing efficient rollback segments.
  • Estimate the volume of rollback data by querying the V$TRANSACTION and V$SESSION views.
  • Estimate the rollback data volume by querying the V$ROLLSTAT view before and after a test transaction.
  • Identify the actions that reduce the amount of rollback.
  • Identify the causes of problems associated with rollback segments.

Unit 4: Monitoring and Detecting Lock Contention

  • Identify the locking mechanism characteristics.
  • Select the statements that characterize DML and DDL locks.
  • Identify the DML lock characteristics.
  • Identify the characteristics of the automatic table lock modes.
  • Match the manual table lock mode with its characteristic.
  • Manually lock a table by using the LOCK TABLE command.
  • Match the DDL lock types with their associated characteristics.
  • Display the object ID of a locked object by querying the V$LOCKED_OBJECT view.
  • Monitor lock contention by using the V$LOCK view.
  • Display all the locks held by using TopSessions.
  • Kill a session to resolve lock contention by using the ALTER SYSTEM KILL SESSION SQL command.
  • Identify the characteristics of deadlocks.

Unit 5: Tuning with Oracle Expert

  • Sequence the steps of the Oracle Expert tuning methodology.
  • Match the Oracle Expert database tuning types with the scenarios in which they are used.
  • Launch Oracle Expert by using the Tuning Pack drawer icon.
  • Create a tuning session by using Oracle Expert.
  • Match the tuning session scope option with its use.
  • View the collection classes available for data collection by using Oracle Expert.
  • Set the Database class collection options by using Oracle Expert.
  • Change the duration and sample frequency when collecting instance statistics by using Oracle Expert.
  • Set the Schema class data options by using Oracle Expert.
  • Identify the characteristics of Environment class data.
  • Set the Workload class data by using Oracle Expert.
  • View the rules by using Oracle Expert.
  • Edit the rules by using Oracle Expert.
  • Analyze the collected data by using Oracle Expert.
  • View the rationale associated with a tuning recommendation by using Oracle Expert.
  • Sequence the steps to save an Oracle Expert report.
  • Generate the recommended implementation files by using Oracle Expert.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

  • At least a 486DX 33Mhz CPU.
  • Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
  • At least 8MB RAM.
  • At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
  • At least a double speed CDROM drive.
  • An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
The network version of this course requires:
  • At least a 486DX 33Mhz CPU.
  • Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
  • At least 8MB RAM and 22MB available hard disk space or file server space.
  • At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC    V3W 1K5 Canada

About Serebra Learning Corporation - Training Provider

Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
More Oracle8i Performance Tuning Training from Serebra Learning Corporation
Click here for more information or to take this course
Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links
Training-Classes.com by Skillbox® 07/18/08
Copyright 1998-2008 skillbox, inc. All rights reserved		 Connecting people who want to learn with people who love to teach
 Are you an Oracle8i performance tuning training provider?
You could be on this page today - for FREE!
This page was last updated on sb5 - 07/18/08 at 04:28:27 - 11:58:53