Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Java Programming
Print PageOracle SQL Performance Tuning Tips & Techniques
Description:
The focus of this tuning course is to illustrate coding techniques that insure a consistent response time between instances and releases of the Oracle database. This course works closely with performance tuning of actual SQL statements as well as covering a variety of Oracle Server tuning topics.
View other Oracle Courses available
View other Oracle Courses available
- Cost: Price on application
- Duration: 2 or 3 days
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
A working knowledge of SQL. A knowledge of SQL Explain Plans is helpful but not necessary.
Topics covered:
How Oracle arrives at an Execution Plan
Index Review/Index Statistics/How Oracle Selects Indexes
Advanced problem-solving topics using V$ Table information
In-depth look at Explain Plans
SQL Trace/Stats Pack
PL/SQL Tuning/Profiling
SQL Troubleshooting/problem solving
Index Review/Index Statistics/How Oracle Selects Indexes
Advanced problem-solving topics using V$ Table information
In-depth look at Explain Plans
SQL Trace/Stats Pack
PL/SQL Tuning/Profiling
SQL Troubleshooting/problem solving
Attendees Receive:
Study guide with presentations and relevant white papers
Book: Oracle SQL Tuning Pocket Reference by Mark Gurry
Diskette full of tuning and problem discovery scripts
Opportunity to ask the tough Oracle questions
A hands-on opportunity to learn more about Oracle, SQL Developer, Eagle Eye, and TOAD
Book: Oracle SQL Tuning Pocket Reference by Mark Gurry
Diskette full of tuning and problem discovery scripts
Opportunity to ask the tough Oracle questions
A hands-on opportunity to learn more about Oracle, SQL Developer, Eagle Eye, and TOAD
Day 1: SQL Statement Tuning:
- Oracle RDBMS Architecture overview
- Understanding/Reading/Interpreting Explain Plans
- Understanding the Rule-based Optimizer
- Understanding the Cost-based Optimizer
- Working with Hints
- Understanding/Reading/Interpreting Explain Plans
- Understanding the Rule-based Optimizer
- Understanding the Cost-based Optimizer
- Working with Hints
Day 2: SQL Troubleshooting Tips and Techniques:
- Index Review/Tips & Techniques
- A close look at sub-query techniques
- Tuning Tool Review: Statspack, Events, Tracing/Tkprof
- Troubleshooting SQL
- Profiling and tuning PL/SQL
- A close look at sub-query techniques
- Tuning Tool Review: Statspack, Events, Tracing/Tkprof
- Troubleshooting SQL
- Profiling and tuning PL/SQL
Optional Day 3: SQL Troubleshooting Tips and Techniques (Advanced Topics):
- Oracle Internals: How Oracle writes
Various Space Management Issues discussed
Monitoring Sorting
- Finding Problem SQL using v$ information
- Monitoring SQL using V$LongOps
- Tuning the network/Tuning the client
- Troubleshooting SQL
- Tuning by Object Placement
Various Space Management Issues discussed
Monitoring Sorting
- Finding Problem SQL using v$ information
- Monitoring SQL using V$LongOps
- Tuning the network/Tuning the client
- Troubleshooting SQL
- Tuning by Object Placement
About Dan Hotka:
Dan Hotka is a Training Specialist who has over 30 years in the computer industry and over 25 years of experience with Oracle products. He is an internationally recognized Oracle expert with Oracle experience dating back to the Oracle V4.0 days. Dans latest book is the SQL Developer Handbook by Oracle Press. He is also the author of Oracle9i Development By Example and Oracle8i from Scratch by Que and has co-authored 7 other popular books including the Database Oracle10g Linux Administration by Oracle Press. He is frequently published in Oracle trade journals, and regularly speaks at Oracle conferences and user groups around the world.