Course : Oracle, application optimization
Practical course - 4d
- 28h00 - Ref. OPT
|
Download in PDF format
Share this course by email
 | Discover application optimization tools and techniques |
| Get to grips with Oracle's integrated optimizer |
| Optimize relational schema and SQL queries |
| Analyze and optimize application performance |
| Parallel query execution |
Intended audience
This course is aimed at application developers and administrators.
Prerequisites
Good knowledge of SQL and PL/SQL.
Course schedule
1 Introduction
- Optimization approach, stages and players.
- Performance problems.
- Particularities of application types. Problem areas.
2 SQL query processing
- Internal mechanisms. Cursor sharing. Link variables in SQL*Plus and Enterprise Manager.
- Cursor sharing. Adaptive Cursor Sharing. Result cache.
Hands-on work
Use bind variables to share cursors.
3 Diagnostics and performance measurement
- Optimization tools. Diagnostic traces. Services with customer applications.
- Trace your session. SQL trace files. SQL trace files.
Hands-on work
Using Tkprof.
4 Optimizing relational schema
- Main structures and access paths. Complete table scan.
- Speed up queries. B*Tree and Bitmap indexes. Index tables. Composite and invisible indexes.
- Index management rules. Temporary global tables.
- Data partitioning. Materialized views. Virtual columns.
Hands-on work
Query optimization.
5 The optimizer
- Data searches. Statistical or syntactic optimization. Statistics for the optimizer.
- Dynamic statistics collection. Data type conversions. Expression evaluation.
- Comparison operators. Subqueries. Join and data access methods.
- Manual query optimization using hints.
Hands-on work
Comparison of statistical and syntactic optimizers.
6 Query optimization
- Design and application. Compound predicates. Tree structures. Group functions.
- Unnecessary loops. Nested views and queries. Synchronized updates. Arrays in PL/SQL.
- Implicit/explicit cursors and batch line retrieval. FORALL.
Hands-on work
Optimization of batch processes.
7 Parallel execution of requests
- Multi-CPU server. Parallel queries. Automatic SQL statement tuning.
- Setting an application. STA advice function. Obsolete object statistics.
- SQL statement profiling. Plan setup flow and SQL profile creation.
- Database Control and STA consulting. Implementation recommendations.
Customer reviews
4,6 / 5
Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed.
ALEXIS L.
06/10/26
4 / 5
The content seems very comprehensive; if I were to be slightly critical, it would be that I find the exercises a bit too rushed (questions jotted down on the fly in a notepad, not everything is marked, and there’ll be no record left after the training…), I would have liked to see a neat document with corrections so that we could fully understand the optimisations and be able to refer back to them. As it stands, I doubt I’ll go back to the 180-page PDF.
FLORIAN C.
06/10/26
3 / 5
There are no structured exercises; they are created on the spot. The documentation is general but lacks detail. However, the trainer is happy to answer any questions we ask.
ANTHONY M.
06/10/26
5 / 5
The trainer is a very good teacher and the content is very interesting. The pace is just right too: slow enough to allow us to copy out the exercises and SQL queries and keep up with the course.He’s always happy to explain things again if necessary or answer any questions we have. He also asks at the start and end of the day whether any of us have any questions.
Publication date : 03/31/2025
PARTICIPANTS
This course is aimed at application developers and administrators.
PREREQUISITES
Good knowledge of SQL and PL/SQL.
TRAINER QUALIFICATIONS
The experts leading the training are specialists in the covered subjects. They have been approved by our instructional teams for both their professional knowledge and their teaching ability, for each course they teach. They have at least five to ten years of experience in their field and hold (or have held) decision-making positions in companies.
ASSESSMENT TERMS
The trainer evaluates each participant’s academic progress throughout the training using multiple choice, scenarios, hands-on work and more.
Participants also complete a placement test before and after the course to measure the skills they’ve developed.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you need special accessibility accommodations? Contact Mrs. Fosse, Disability Manager, at psh-accueil@orsys.fr to review your request and its feasibility.
This course is aimed at application developers and administrators.
PREREQUISITES
Good knowledge of SQL and PL/SQL.
TRAINER QUALIFICATIONS
The experts leading the training are specialists in the covered subjects. They have been approved by our instructional teams for both their professional knowledge and their teaching ability, for each course they teach. They have at least five to ten years of experience in their field and hold (or have held) decision-making positions in companies.
ASSESSMENT TERMS
The trainer evaluates each participant’s academic progress throughout the training using multiple choice, scenarios, hands-on work and more.
Participants also complete a placement test before and after the course to measure the skills they’ve developed.
TEACHING AIDS AND TECHNICAL RESOURCES
• The main teaching aids and instructional methods used in the training are audiovisual aids, documentation and course material, hands-on application exercises and corrected exercises for practical training courses, case studies and coverage of real cases for training seminars.
• At the end of each course or seminar, ORSYS provides participants with a course evaluation questionnaire that is analysed by our instructional teams.
• A check-in sheet for each half-day of attendance is provided at the end of the training, along with a course completion certificate if the trainee attended the entire session.
• The main teaching aids and instructional methods used in the training are audiovisual aids, documentation and course material, hands-on application exercises and corrected exercises for practical training courses, case studies and coverage of real cases for training seminars.
• At the end of each course or seminar, ORSYS provides participants with a course evaluation questionnaire that is analysed by our instructional teams.
• A check-in sheet for each half-day of attendance is provided at the end of the training, along with a course completion certificate if the trainee attended the entire session.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you need special accessibility accommodations? Contact Mrs. Fosse, Disability Manager, at psh-accueil@orsys.fr to review your request and its feasibility.
This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.
Dates and locations
Select your location or opt for the remote class then choose your date.
Remote class
Dernières places
Date garantie en présentiel ou à distance
Session garantie
This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.