OR215

Optimizing Oracle 11g/12c Databases

92%

overall satisfaction for this course

?Average calculated from scores obtained from 88 participants who took this course.
  • Duration 2 days
  • Regular fee 1 275
  • Preferential fee 1 150?
  • Locations
  • Laboratory
    course
SUMMARY
DETAILS

Objectives

To provide the knowledge and skills required to perform database diagnostics using effective settings in order to correct problems associated with performance.

Targeted audience

Experienced Oracle 11g database administrators.

Prerequisite

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

Customer Testimonials

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

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

Content

  • 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)

Are you interested in this training course ?

Only private sessions of this course are currently available.

Request a quote

Trainer(s) assigned(s)

Other course(s) in this category