Training objectives
- Understand how Oracle uses the system resources (CPU, I/O, Memory) and configure them
- Learn how the Cost Based Optimizer (CBO) optimizes the access to your data
- Know everything about execution plan operations (full table scans, index access, sorts, etc.)
- Monitor the performance with Standard and Enterprise Edition features (from the Diagnostic to the Tuning Pack options)
- Learn the tuning of queries via features available to the developer and/or DBA
- Understand optional Oracle features such as Exadata and In-Memory
Topics
- Memory Sizing: SGA, PGA
- I/O calls performed by Oracle
- CBO, cardinality, cost, optimization, execution plan, hints
- Statistics: system, object, dynamic
- Full Table Scan and indexing
- Sorts and Group By
- All join methods
- Statspack, AWR reports, ASH
- Tkprof, dbms_xplan, SQL Monitoring
- SQL Profiles, SQL Patch, SQL Baselines
- Partitioning, Compression, Result Cache, Parallel Query
- BI queries: Star transformation, Materialized views
Method
- Presentation with countless practical exercises and trainings
- Case studies, live demos, discussions
- Networking during coffee break, lunch, and apéro on last day (included in price, except for on-site workshop courses)
Target groups
- Database administrators (DBAs) wanting to improve the system performance, Database developers wanting to improve the application performance
Language & documentation
- Workshop training normally held in English; French or German possible instead as course languages
- Documentation: content details, scripts, case study solutions as PDF file (in English)
Equipment
- On-site training: As this training is provided on a Cloud platform, participants must be equipped with a laptop in order to access the Cloud infrastructure through an ssh client.