|
|
|
 |
O9i-PTOracle9i Performance Tunning
This course represents the methodology used for increase of productivity of server Oracle9i. Students study various resources and the methods of diagnostics necessary for detection and elimination of typical problems of productivity, originating at maintenance of database Oracle. Course questions of customization of a copy and database Oracle, such as customization of usage of memory, diagnostics of a competition for resources, customization of input-output, etc. in detail considers. Students also receive the knowledge necessary for customization of applications and SQL-operators. The course includes the practical occupations fixing received knowledge and skills. The course is calculated on employees of services of technical support, system administrators, managers of databases.
Upon termination of course students will learn:
- To understand process of customization;
- to use resources of diagnostics and customization;
- to customize structures of memory;
- to configurate databases and to customize input-output;
- to optimize sortings;
- to find out a competition for latches (latches);
- to customize segments of rollback;
- to find out and watch a competition of lockings;
- to customize divided server Oracle (Oracle Shared Server);
- to customize applications;
- effectively to use blocks Oracle;
- to customize SQL-sentences;
- to customize the operating system and to use Resource Manager.
Necessary preparation Starting to learning course, students should: to possess knowledge in size of courses O9i-SQL and O9i-DBA I.
This course will help you to prepare for the next tests:
1Z0-033 Oracle 9i Database: Performance Tuning
Education coast on cource - USD 860
Cource duration (days) - 5
|
|
