Konsultasiya almaq
Training Center MUKКурсыOracleDatabaseОсновы администрирования Oracle 11g, часть II

Oracle Database 11g: Administration Workshop I

Kursun kodu
MUK-ODB2
Müddət
5 Gün, 40 Saat
Kursun təsviri
Məqsədlər
Tələblər
Kursun proqramı
Kursun təsviri

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.

Məqsədlər

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
Tələblər

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
Kursun proqramı

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
Ən yaxın kurs üçün qeydiyyat
Oracle Database 11g: Administration Workshop I
Kursun kodu:
MUK-ODB2
Müddət:
5 Gün, 40 Saat
Qeydiyyatan keç
Konsultasiya almaq
Свяжитесь со мной
Konsultasiya almaq
Отправить заявку
Vebinara qeydiyyat
Отправить заявку
Müraciətiniz qəbul olundu!
Yaxın zamanda sizinlə əlaqə saxlanılacaq.