CTS

Individual training solutions

+48 12 655 17 36  

Oracle

OR 4 Training Optimization (tuning) databases Oracle (SQL)

Training name: OR 4 Training Optimization (tuning) databases Oracle (SQL)

Duration (in days): 4 days

Description

In order to train teaching diagnosing and the problem solving is associated with the database Oracle.

Objectives

Student learn how to diagnose and solve common performance problems.

Audience

The training is for administrators, designers and programmers of databases Oracle.

PreRequisites

Acquaintance of the Windows environment, SQL and of administration of databases Oracle

Topics

1.Methodology of tuning database
2.Optimalization of data structures
3.Optimalization of data access
4.Alert file and trace files
5.Tools and database catalog views used during tuning
6.Optimalization of SQL statements
7.Tuning operating system
8.Configuring database
9.Effective use of database blocks
10.Optimalization of I/O.
11.Tuning Oracle instance
12.Tuning redo logs
13.Tuning undo segments
14.Optimalization of sorting
15.Monitoring and lock detection
16.Tools in Oracle Enterprise Manager

In case customers from Poland prices can be negotiated

VAT not incl. It concerns only customers from Poland

%}