| |
|
| |
Oracle9i Database - Performance Tuning Training Class
Course ID: 5876
|
|
| |
|
|
| |
|
|
| |
Oracle9i Database - Performance Tuning Training Seminar
Overview: This course provides students with the concepts needed to properly tune their Oracle9i?? database for optimal performance.
At Course Completion: - Understand tools and methodologies for tuning your database. - Monitor and tune the database buffer cache. - Monitor and tune the library cache, dictionary cache, large pool, and other memory structures. - Manage Java memory and tune Oracle processes for performance. - Understand the physical structure of a database and tune disk I/O. - Identify and correct issues with locks and latches. - Tune applications by using the correct table and index types. - Analyze and improve the performance of SQL statements. - Measure sort performance and manage sort-related parameters. - Use Oracle Resource Manager to allocate operating system resources and tune the shared server.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: Introduction to Performance Tuning
Performance, Scalability, and Reliability Software Development Lifecycle Oracle Tuning Tools Tuning Methodology
|
|
Lesson 2: Oracle Memory Tuning I
Oracle Memory Architecture Database Buffer Cache Monitor the Hit Ratio Buffer Cache Advisory Statistics Other Buffer Tuning Issues
|
Lesson 3: Oracle Memory II
Shared Pool Structure Oracle Library Cache and Dictionary Cache The Large Pool Process and Session Memory
|
Lesson 4: Other Instance Values
Manage Java Memory Database Writer Processes The Redo Log Buffer Database Checkpoints
|
Lesson 5: Database I/O
Manage the Physical Layout of Oracle Redo Log Files Temporary Tablespaces Undo Management
|
|
Lesson 6: Locks and Latches
Locks Lock Contention Oracle Latches
|
Lesson 7: Application Tuning
Review of Terminology and Concepts Table Types Index Types Partitioned Objects
|
Lesson 8: Tuning SQL Statements
Overview of SQL Execution Database Object Statistics Hints and Plan Stability Resource-intensive SQL Histograms
|
Lesson 9: Sorts
Sorts Sort Parameters for Dedicated Servers Sort Parameters for Shared Servers
|
|
Lesson 10: Other Tuning Topics
Use Performance Manager to Monitor an Operating System Database Resource Manager Shared Server Tuning
|
|
|
|
|
|
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
Oracle9i SQL - Introduction Oracle9i Database - Fundamentals I Oracle9i Database - Fundamentals II
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
| |
Oracle9i Database - Performance Tuning Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5876
| Course Duration: 5 Days
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request More Info |
|
Print/Fax Register |
|
|
| |
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|