 |
|
Oracle Performance Tuning
 Click here to contact us
Course Overview
Oracle Performance Tuning introduces students to a database server tuning methodology that can be used to improve the performance of the Oracle server and design effective tuning strategies for today's business enterprise. Students will use a variety of Oracle tools to address tuning scenarios and learn how to recognize, troubleshoot and resolve common performance-related problems in administering the latest version of the Oracle Database through case studies and exercises.
Course Goals
- To reinforce knowledge of the workings of key tuning concepts, such as SQL statement processing and optimization, index and join theory, parallel operations, memory structures and physical storage
- To reinforce DBA awareness of the entire environment that a database operates in, including the hardware, operating system, network and applications.
- To learn how to outline a tuning strategy for a business enterprise
- To learn how to use Oracle tools to perform diagnostics to resolve performance problems
- To learn how to reconfigure file and database structures for performance and other considerations
- To acquire knowledge of how to allocate memory and disk resources for optimal performance
- To learn how to diagnose and troubleshoot memory and disk resource contention problems
- To implement proactive monitoring and performance tuning techniques for different types of applications
Prerequisites
- SQL & SQL*Plus
- Database administration
Who Should Attend?
Course Materials
- Performance Tuning Course Notes
- Performance Tuning Sample Script Disk
Duration
Tuition
Course Outline
- Tuning purpose and approach
- DBA role
- Working with designers, developers and system administrators
- Proactive tuning
- Tuning memory
- Database storage configuration
- Tablespaces and datafiles
- Database objects
- Partitioning
- Redo, undo, archive, temp space
- Oracle managed files
- Automatic storage management
- Design and code
- ERD
- Normalization/denormalization
- Query processing
- SQL vs. PL/SQL vs. other languages
- Native PL/SQL compilation
- Cost-based optimizer
- Optimizer statistics
- Execution plans
- Stored outlines
- Histograms
- Joins
- Hints
- Parallelism
- Sorts
- Bulk data operations
- Network
- Multithreaded server
- Connection manager
- Performance planning
- Design
- Data types
- Object-relational
- Database objects
- LOBS, CLOBS, BLOBS, NCLOBS
- Data warehousing overview
- External tables
- Resource manager
- Clustered architectures
- ERPs
- Reactive tuning
- Performance diagnosis, problem identification, troubleshooting
- Diagnostic and troubleshooting tools
- Oracle enterprise manager
- Advisor framework
- Tracing
- Useful data dictionary performance queries
- Table, index monitoring
- Locks and latches
- Miscellaneous
- Pertinent DBMS* packages
- Pertinent initialization parameters
- Tuning backup and recovery and data guard
- Upgrades
- Putting it all together
- Tuning methodology
- Performance management
- External database topics
- Operating system
- Storage
- Network
- Applications
|
|
|
|
