Optimizing Oracle 11g/12c Databases


overall satisfaction for this course

?Average calculated from scores obtained from 85 participants who took this course.
  • Duration 2 days
  • Regular fee 1 150
  • Preferential fee 995?
  • Locations
    • Montreal
  • Laboratory

Formation path :

Databases Training Paths

View path


To provide the knowledge and skills required to evaluate the operational characteristics of an Oracle 11g database and correct problems associated with performance.

Targeted audience

Oracle 11g database administrators.


Knowledge of Oracle (Course OR201) and of system administration (Windows Server or Unix).

Customer Testimonials

Super good trainer, good knowledghe, good dynamic, interesting and useful content.

Pascal R. / Conseiller Support Applicatif, Hydro-Québec


  • The steps involved in processing SQL instructions
  • Causes of performance problems
  • The various settings that affect performance
  • Problems related to SGA, PGA and automatic memory management (AMM)
  • Generating statistics (standard, dynamic and advanced)
  • Generating and interpreting an execution plan (DBMS_XPLAN)
  • Diagnosing problems associated with temporary tablespace (TRI)
  • The various index types (B*TREE and BITMAP) and how to maximize their performance
  • Diagnosing table and index fragmentation
  • Introduction to the DB EXPRESS console
  • Managing adaptive SQL plans
  • Overview of the Oracle ADVISOR tools (memory, segment, ADDM)


*Unless stated otherwise, all sessions are in French.
  • Montreal

    November 21 to November 22 2016

  • Montreal

    June 5 to June 6 2017

Trainer(s) assigned(s)

Other course(s) in this category