SCN GmbH

Oracle Performance Management and Tuning

Seminar / Training Oracle Performance Management and Tuning

  • Introduction
  • Basic Tuning Diagnostics
  • Using the automatic workload repository
  • Defining the scope of performance problems
  • Using metrics and alerts
  • Using baselines
  • Use of AWR-based tools
  • Real-time database operation monitoring
  • Monitoring applications
  • Identifying problematic SQL statements
  • Influencing the optimizer
  • Reduce the cost of SQL operations
  • Using SQL Performance Analyzer
  • SQL Performance Management
  • Using database rendering
  • Tuning the shared pool
  • Tuning the buffer cache
  • Tuning PGA and temporary space
  • Automatic memory
  • Performance Tuning Summary with Wait Times

Requirements

Oracle 19c Administration

This seminar has the level "Administration / Basic andstructure".

If you are not sure whether this course is the right level for you, you can check this with the trainer in advance.

We conduct this seminar online for you. You can book the training as a public seminar or as a company seminar. The practical exercises are carried out in our Remotelab and make up 40-50 percent of the seminar.

Your contacts

We offer seminars with a high practical relevance. The contents and exercises are geared to your daily tasks in the company and completely dispense with advertising references to other products of the software manufacturer.

All our training courses are manufacturer-independent. This enables us to offer critical considerations of the products themselves and comparisons with competitors of the manufacturer in the seminar. The course contents are our own and derived from the practical experience of our trainers in projects.

Of course, the contents of company seminars can be individually adapted to your needs. Please do not hesitate to contact us.
Oops, an error occurred! Code: 2024112119055305446461