Oracle SQL Performance Tuning Tips & Techniques Professional Training Solutions Ltd

Price: TBA

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 2 to 3 Days

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

Course Location

Show map Location Westland Square Pearse St Dublin 2 Ireland

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

View more Virtual classroom training for Oracle online courses See all Oracle Courses

See all current SQL Server and Oracle jobs in Ireland

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.