OR1703

Ladda ner som PDF

Oracle Database 11g: Administration Workshop II Release 2

This course takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a much deeper understanding of possibly the most important job of a DBA – backup and recovery.

Målgrupp

  • Database Administrators
  • Support Engineer
  • Technical Administrator
  • Technical Consultant

Förkunskaper

Required Prerequisites

Oracle Database 11g Database Administration Oracle Database 11g: Administration Workshop I Release 2

Suggested Prerequisites

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

Informator Training Cloud

Vår utbildningsportal stöttar dig genom hela utbildningen. Portalen är tidsbesparande och utformad för att ge dig som deltagare en mer effektiv inlärning - som leder till bättre resultat och större kunskapstillämpning efter kursen. Läs mer här >

Learn To:

Automate DBA tasks with the Scheduler. Diagnose and repair data failures with Flashback technology. Manage space to optimize database storage and to be able to respond to growing space requirements. Monitor and manage major database components, including as memory, performance and resources. Secure the availability of your database through appropriate backup and recovery strategies.

Backup & Recovery

The concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios.

Performance Evaluation

Tasks Also, the DBA learns how to manage memory effectively and how to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are also covered.

Live Virtual Class Format

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made

Course Objectives

  • Back and recover a database (and its parts) with RMAN... Läs mer

Learn To:

Automate DBA tasks with the Scheduler. Diagnose and repair data failures with Flashback technology. Manage space to optimize database storage and to be able to respond to growing space requirements. Monitor and manage major database components, including as memory, performance and resources. Secure the availability of your database through appropriate backup and recovery strategies.

Backup & Recovery

The concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios.

Performance Evaluation

Tasks Also, the DBA learns how to manage memory effectively and how to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are also covered.

Live Virtual Class Format

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made

Course Objectives

  • 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
  • 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

Course Content>>

 

Utbildningen levereras i samarbete med

Kursfakta

Kurs-ID: OR1703
Längd: 5 dagar
Pris exkl moms: 30 300 kr
Inregistrering: 09.00
Kursstart: 09.30
Kursslut (ca): 17.00

Frågor om kursen?

Har du frågor om kursens innehåll, leveransdatum/ort eller behöver en företagsanpassad variant? Fyll i formuläret nedan!


Kan betalas med:
TRAINING CARD

Ort och datum

Stockholm
11 dec-15 dec
Boka nu!
Malmö
11 dec-15 dec
Boka nu!

Tipsa