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

Oracle Database 11g: Administration Workshop I

Код курсу
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


  • 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 I
Код курсу:
5 Днів, 40 Ак. Годин
Отримати консультацію
Свяжитесь со мной
Отримати консультацію
Отправить заявку
Реєстрація на вебінар
Отправить заявку
Ваша заявка отримана!
Ми зв`яжимося з вами найближчим часом.