Oracle Database- and Instance Tuning

WE GET YOU IN SHAPE FOR FIELD USE.schulungen

For your trainings and workshops, H&L place particular value to individuality.
We will train you on site on your own systems, tailored to your requirements. Thus we can ensure a highly practical approach.
Here, you will benefit from the competence, the know-how and the long-lasting project expertise of our instructors.

Course Number: HL-ORA6

Title: Oracle Database- and Instance Tuning

The Oracle architecture allows for the optimal usage of all resources of a server. To do that, the parameterization of the Oracle system has to be conducted with attention to the transaction profile of the accessing application. System monitoring and a bottleneck analysis are necessary for a continuous fine tuning.

This course provides the necessary knowledge on a theoretical and practical level.

Agenda
  • Architecture Oracle Instance and Database
  • Parameterization of SGA and PGA
  • AWR/STATSPACK
  • System Statistics and System Events
  • Bottleneck Analysis
  • I/O Configuration
  • Tablespace Settings