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

+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

Почта

edu@fors.ru

Oracle9i Performance Tuning: Managing Memory and Disk I/O

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

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

Course Overview
 
This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database.

Learn To

  • Match the optimizer modes with their descriptions.
  • Match the OPTIMIZER_MODE parameter values with their description.
  • Identify the methods of creating stored outlines.
  • Identify the three major areas of the Shared Pool.
  • Identify the parameters used to tune the Shared Pool.
  • Identify the goals for tuning the Library Cache.
  • Identify the descriptions of redo entries.
  • Match the statistics used to diagnose disk I/O contention with their descriptions.
  • Identify the two parameters that allow the DBA to limit the amount of memory used for each Java session.
  • Identify the performance guidelines to reduce the activity on an overloaded disk.
  • Identify the methods of striping.
  • Identify the initialization parameter that indicates the size of read calls during full table scans.

Audience

The intended audience for this course includes Database Administrators, Technical Support Professionals, and System Administrators.

Записаться на курс: Oracle9i Performance Tuning: Managing Memory and Disk I/O

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



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

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

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

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