WE GET YOU IN SHAPE FOR FIELD USE.
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.
- Architecture Oracle Instance and Database
- Parameterization of SGA and PGA
- System Statistics and System Events
- Bottleneck Analysis
- I/O Configuration
- Tablespace Settings