Home
> Training
> Peformance Tuning
| Duration: |
32hrs |
| Price: |
$700.00 |
| Training Method: |
Instructor-led Training |
| Class Schedule |
Weekdays, Evenings &
Weekends |
This course will introduce participants
to a series of tuning steps which can be used to improve
the performance of the Oracle8i Server. The focus is on
database rather than specific operating system performance
issues. Participants will gain practical experience tuning
an Oracle database. Using a variety of 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 the opportunity to walk
through real-world performance tuning scenarios including
problem diagnosis and performance enhancement.
This course is designed to
prepare you for the corresponding Oracle Certified Professional
exam: Exam #1Z0-024
Oracle8i Database
Backup and Recovery
Oracle8i Database Architecture and
Administration
Configure memory and disk resources
to optimize sort operations
Detect and resolve latch and lock contention problems within
the Oracle database environment
Diagnose and resolve performance issues associated with
the multithreaded server
List the options to enhance performance tuning requirements
for different types of applications
Reconfigure file structures for performance and other considerations
Use Oracle tools to diagnose performance problems
Identify and resolve I/O, data storage and database configuration
problems
List the important steps for outlining a tuning methodology
Listing the different roles associated
with the tuning process
Defining the steps associated with the tuning process
Identifying different tuning goals
Identifying the location
and usefulness of the alert log file
Identifying the location and usefulness of the background
and user process trace files
Collecting statistics using the dynamic troubleshooting
and performance views
Diagnosing statistics using the UTBSTAT/UTLESTAT output
report
Identifying the different types of latches
Retrieving and displaying wait events
Setting events through OEM to be alerted about predefined
situations
Using appropriate OEM tuning tools
Tuning the library cache
and data dictionary cache
Measuring the shared pool hit percentage
Sizing the shared pool appropriately
Pinning objects in the shared pool
Tuning the shared pool reserved space
Listing the UGA and session memory considerations
Describing the how the buffer cache
is managed
Calculating the buffer cache hit ratio
Examining the impact of adding or removing buffers
Creating multiple buffer pools
Sizing multiple buffer pools
Monitoring buffer cache usage
Making appropriate use of table caching
Identifying performance issues associated with buffer cache
latches
|
|
