Расписание курсов

+7 (495) 913-75-75 доб.221

+7 (495) 668-08-42

+7 (812) 441-33-15

+7 (901) 374-07-97

+7 (383) 263-31-70

+7 (861) 944-79-98

+7 (391) 272-07-31



Oracle9i Performance Tuning: Optimizing Sorts and Minimizing Contention

Посмотреть расписание этого курса

  • Код курса: 64333
  • Длительность: 8 д.
  • Цена: 4 480 р.
Записаться Добавить в корзину

Описание курса

Course Overview
The content of this course includes details about each component of an Oracle database instance, such as data blocks, disks, memory, CPU, and dynamic views. Students learn about migration and chaining, reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting.

Learn To

  • Match the component of database storage with its definition.
  • Avoid dynamic allocation of extents by using the ALTER TABLE command.
  • Avoid the dynamic allocation disadvantages by creating a locally managed tablespace.
  • Sequence the steps in the sort process.
  • Set the SORT_AREA_SIZE parameter by using the ALTER SESSION command.
  • Identify the tuning sort goals.
  • Match the uses of rollback segments with their definitions.
  • Select the characteristics of rollback segment activity.
  • Identify the characteristics of rollback segment growth.
  • Identify the locking mechanism characteristics.
  • Select the statements that characterize DML and DDL locks.
  • Identify the DML lock characteristics.
  • Sequence the process steps of the Oracle shared server configuration.
  • Identify the characteristics of the Oracle shared server.
  • Query a dispatcher process to determine the process status using the V$DISPATCHER view.


The intended audience for this course includes database administrators and application developers, regardless of role or experience level.

Записаться на курс: Oracle9i Performance Tuning: Optimizing Sorts and Minimizing Contention

Начало курса:

Отправьте другу или начальнику ссылку на почту
Заявка на обучение

Заявка на обучение

Записаться на курс:

Выберите дату начала курса: