What's New

The Wait for Visual Studio 2008 is Over!

One may picture, too, the sudden shifting of the attention, the swiftly spreading coils and bellyings of that blackness advancing headlong,...

Oracle9i Database Performance Tuning

Oracle9i Performance Tuning
Course ID: D11299 | Duration: 5 Days
Class times are from 9 A.M. to 5 P.M.
Description:
This course will introduce participants to a series of tuning steps, which can be used to improve
the performance of the Oracle9i Server. The focus is on Database and Instance tuning rather
than specific operating system performance issues. Participants will gain practical experience
tuning an Oracle database. Using the available Oracle tools, participants also learn how to
recognize, troubleshoot and resolve common performance related problems in administering an
Oracle database. The class includes a one -day interactive workshop that provides participants
with ‘real-world’ experience including problem diagnosis and performance enhancement.
Audience:
? Technical Support Professionals
? System Administrators
? Database Administrators
Required Prerequisites:
? Oracle9i DBA Fundamentals II
? Oracle9i DBA Fundamentals I
Suggested Prerequisites:
? Introduction to SQL (5 days)
Course Objectives:
? List the important steps for outlining a tuning methodology
? Use Oracle tools to diagnose performance problems
? Reconfigure file structures for performance and other considerations
? Identify and resolve I/O, data storage, and database configuration problems
? Detect and resolve latch and lock contention problems within the Oracle database
environment
? Configure an Oracle Database with an emphasis on good performance.
? Configure memory and disk resources to optimize sort operations
? Diagnose and resolve performance issues associated with Shared Server
? Configure Resource Manager to control resource usage
? Perform day-to-day monitoring on an operational database using STATSPACK
Course Topics:
Oracle Performance Tuning Methodology
Job Roles in tuning
Tuning during development phases
Service Level Agreements
Most common performance tuning problems
Tuning for Different Types of Applications
Tuning Methodology
Oracle Alert and Trace Files
Alert log file
Background process trace files
User trace files
Tuning Tools
Dictionary views providing statistics
Dynamic performance views
Oracle Wait Interface
DBA developed tools
OEM [describe how to use EM in the other lessons]
ANALYZE command and DBMS_STATS package
Sizing the Shared Pool
Library cache tuning
? Library Cache Tuning Issues
? Shared Server UGA Tuning
? Guidelines for different application types
? Fragmentation
? Dictionary Cache (DC) Tuning
? Dynamically resizing the Shared Pool
Suggested Next Courses:
Please check with your Education Representative to determine the appropriate follow up
course.
Related Courses:
No related Technology Bases Tr aining Courseware is currently available.

AttachmentSize
Oracle 9i Performance Tuning.pdf18.09 KB
Code: 
9i Tuning
Duration: 
5
Price: 
6000000
Schedule: 
Available Upon Request