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