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 265
  • Preferential fee 1 075?
  • Locations
  • Laboratory
    course
Parcours

Formation path :

Databases Training Paths

View path
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

Excellent course. Very energetic trainer.

Martin O. / Analyste informatique, Ville de Montréal

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 by this training course ?

This training course is available in private training. Enter your email to be contacted by a member of our team for more informations.

Invalid email address

Trainer(s) assigned(s)

Other course(s) in this category