|
|
|
 |
O8PTWOracle8: Seminar on productivity customization
The course acquaints with a technique of customization of productivity of server Oracle8. The main attention is given in course to questions of customization of databases. Questions of customization of productivity of the operating system do not enter into a circle of cases in point. Students gain practical experience of customization of database Oracle, study ways of detection and elimination of the widespread problems of productivity. The one-day practical work allows to apply the investigated methods of customization of databases to customization of a concrete database.
In course ways of customization of productivity of a database, tools of diagnostics of productivity, questions of customization of applications and SQL commands, questions of customization of memory, input operations of output, lowering of a competition for resources are considered.
the Circle of students:
Managers of networks,
Managers of databases,
Experts on technical support,
System administrators,
Developers of applications,
the Manual of intelligence systems of handle.
Necessary preliminary preparation:
Oracle8: administration of a database.
The program of course:
- the Technique of customization of databases, main steps of customization
- Toolkit Oracle for diagnostics of problems of productivity
- Reconfiguring of database structure with a view of rise of productivity. Customization of input operations of output
- Customization of applications, optimization SQL Customization of areas of memory. Customization of a divided pool and cache data buffers Allocation of space for segments and inside a bulk and productivity
- Customization of segments of rollback
- Customization of process of journalizing
- Optimization of sortings
- Revealing and elimination of problems of a competition for resources
- Diagnostics and elimination of problems of productivity in a configuration of a multistream server
- and various applied environments
- Customization with help Oracle Expert
- Practical exercises under scripts
For familiarity are recommended Possibility of rise of productivity courses:
Introduction in Oracle8: SQL and PL/SQL
Oracle8: Development of program units on PL/SQL
Oracle8: Administration of databases
Oracle8: the Practical work on saving and restoring of databases.
Education coast on cource - USD 1000
Cource duration (days) - 4
|
|
