Course details
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.
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
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
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
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
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
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. Dan’s 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.
Updated on 08 November, 2015Course Location
About Professional Training Solutions Ltd
Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.
they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.
their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:
restructuring for competitiveness
productivity improvements through updating work processes to match new technology
managing outstheircing
strategic financial planning and engineering
their methodology is to:
Work closely with clients to understand and help them prioritise their needs
Design and deliver the best mix of training activities and consultancy to establish the competencies required
Provide ongoing coaching to sustain the improved practices and processes
they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.
their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.
See all Professional Training Solutions Ltd courses Are you from Professional Training Solutions Ltd ? Claim your course!
Courses you can instantly connect with... Do an online course on SQL Server starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- SQL Global CoursesEUR 14
EUR 131Duration: 2 Hours - SpeedGrade CC 1TRAININGEUR 20
EUR 143Duration: Upto 14 Hours
