|
|
|
O8i-PTOracle8i Server Performance Tuning
The course acquaints with tile steps of the customization, permitting to raise productivity of server Oracle8i. The main attention is given to a database, instead of concrete questions of productivity of the operating system. Students gain practical experience of customization of databases Oracle, study to recognize, diagnose and solve problems of administration of databases Oracle, connected with productivity. The course includes an one-day interactive practical work which allows students to pass step by step scripts from " the real world ". Upon termination of course students will learn:
- to name the important steps of methodology of customization; - to use tools Oracle for diagnostics of problems of productivity; - to change structures of files for rise of productivity; - to use signal files and files of tracing;
- To reveal and solve problems of input / output, data storage and a configuration of a database; - to reveal and solve the problems connected to latches and conflicts of lockings; - to create configurations of memory and resources on disks for optimization of sorting; - to control the mixed load; to diagnose and solve the problems connected to a multithreaded server; - to name possibilities of rise of requirements to productivity of applications of different types. Necessary preparation Starting to learning course, students should: - to know Performance Manager product Oracle Enterprise Manager; - to know Oracle architecture. It is recommended to hear courses: "Oracle8 databases administration"; O8i-DBA or to possess equivalent knowledge.
This course will help you to prepare for the next tests: 1Z0-024 Oracle8i: Performance Tuning
Education coast on cource - USD 720 Cource duration (days) - 5
|
|