O9i-ATOracle9i Application Tuning
This course takes up questions of rise of productivity of the applications based on databases, taking place under the control of server Oracle9i. guidelines on designing, programming and improvement of productivity of applications will be given. Process of execution of SQL-inquiries by server Oracle and as the schedule of execution of inquiry is created will be investigated. In execution time of numerous laboratory operations, students will master engineering of improvement of productivity of execution of SQL-inquiries and PL/SQL-procedure.s questions of customization of parameters of session for applications of class DSS or OLTP. Contents of course - Acquaintance to questions of customization of productivity will be discussed.
- Architecture of server Oracle9i.
- Effective memory utilization.
- the Expedition of execution of SQL.
- Increase in speed of execution of connection of tables (join) and subrequests.
- Directives for handle of the optimizer (Hints.)
- Methods of operation with the big tables.
- Methods of operation with the big indexes.
- Setup of parameters of session.
- Rise of efficiency codes of applications.
- Dynamic SQL.
- Possibilities in the field of repositories.
Students Systems analysts, developers, designers, managers and staff of services of support. Preliminary preparation Is required knowledge of languages SQL and PL/SQL, principles of relational databases, various types of objects of databases. It is recommended to hear course O8i-Intro or O9i-Intro or to hear a pair of courses O9i-SQL and O9i-PLSQL. It is desirable to have an operational experience in Oracle environment six months and more.
Education coast on cource - USD 441
Cource duration (days) - 3
|
