Получить консультацию
Training Center MUKКурсыOracleDatabaseОсновы администрирования Oracle 11g, часть II

Oracle Database 11g: Administration Workshop II

Код курса
MUK-ODB2
Продолжительность
5 Дней, 40 Ак. Часов
Описание курса
Цели
Требования
Программа курса
Описание курса

Course overview

This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You’ll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

Цели

Course objective

  • Configure the Oracle Database for optimal recovery
  • Configure the database instance such that resources are appropriately allocated among sessions and tasks
  • Schedule jobs to run inside or outside of the database
  • Use compression to optimize database storage and duplicate a database
  • Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager)
  • Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
  • Use an appropriate and flexible memory configuration for your database
  • Identify burdensome database sessions and poorly performing SQL
Требования

Suggested Prerequisite

  • Working knowledge of SQL and how to use PL/SQL packages

Required Prerequisite

  • Oracle Database 11g: Administration Workshop I Ed 2
  • Oracle Database 11g Database Administration

Audience

  • Administrator
  • Database Administrator
  • Implementer
Программа курса

Course outline

  1. Core Concepts and Tools of the Oracle Database
  2. Configuring for Recoverability
  3. Using the RMAN Recovery Catalog
  4. Configuring Backup Settings
  5. Creating Backups with RMAN
  6. Restore and Recovery Task
  7. Using RMAN to Perform Recovery
  8. Monitoring and Tuning RMAN
  9. Diagnosing the Database
  10. Using Flashback Technology I
  11. Using Flashback Technology II
  12. Performing Flashback Database
  13. Managing Memory
  14. Managing Database Performance
  15. Managing Performance by SQL Tuning
  16. Managing Resources
  17. Automating Tasks with the Scheduler
  18. Managing Space in Blocks
  19. Managing Space in Segments
  20. Managing Space for the Database
  21. Duplicating a Database
Регистрация на ближайший курс
Oracle Database 11g: Administration Workshop II
Код курса:
MUK-ODB2
Продолжительность:
5 Дней, 40 Ак. Часов
Зарегистрироваться
Получить консультацию
Свяжитесь со мной
Получить консультацию
Отправить заявку
Регистрация на вебинар
Отправить заявку
Ваша заявка получена!
Мы свяжемся с вами в ближайшее время.