O8i-ATOracle8i applications productivity optimization
This course takes up questions of rise of productivity of the applications based on databases, taking place under the control of server Oracle8i. During training guidelines on designing, programming and improvement of productivity of applications are given. Process of execution of SQL-inquiries by server Oracle and principles of construction of the schedule of execution of inquiry is studied. During passing numerous laboratory operations, students will master engineering of improvement of productivity of execution of SQL-inquiries and PL/SQL-procedure.s the Contents of course - Acquaintance to questions of customization of productivity.
- Oracle8i server architecture for developers.
-
Effective utilization of memory.
- the Expedition of execution of SQL operators.
- Tools EXPLAIN PLAN and AUTOTRACE.
- Utilities SQLTRACE and TKPROF.
- 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 of a code of applications.
- Dynamic SQL.
- Possibilities in the field of repositories.
- Objective-relational databases.
Education coast on cource - USD 441 Cource duration (days) - 3
|