Préparation à la Certification : Oracle Database 12c : Installation et Administration


Préparation à la Certification : Oracle Database 12c : Installation et Administration

Prix: 220 €Durée: 1 jourCode de Réference: D96684 Catalogue ,
Oracle Database 12c
Print Friendly, PDF & Email

Ce séminaire de préparation et de révision vous aide à préparer l'examen de certification Oracle Database 12c: Installation et Administration (1Z0-062).

Objectifs de la formation :

  • Review key technologies and certification concepts related to Oracle Database 12c: Advanced Administration.
  • Understand the depth and breadth of the Oracle Database Administrator.
  • Get information that will help you complete your preparation and study.
  • Receive tips and information that will help you on the test.
  • Learn from one of Oracle University's top instructors.

Public :

Cette formation s'adresse aux concepteurs de base de données, développeurs de base de données et administrateurs de base de données.

Pré-requis :

Avoir suivi les cours Oracle Database 12c: SQL and PL/SQL Fundamentals, Oracle Database 12c: Administration Workshop et Oracle Database 12c: Install and Upgrade Workshop ou disposer de connaissances et compétences équivalentes.

Programme :

Exploring the Oracle Database Architecture

List the architectural components of Oracle Database Explain the memory structures Describe the background processes Explain the memory structures

Oracle Database Instance

Understand initialization parameter files Start up and shut down an Oracle database instance View the alert log and access dynamic performance views

Configuring the Oracle Network Environment

Configure Oracle Net Services Use tools for configuring and managing the Oracle network Configure client-side network Troubleshoot network issues Configure communication between databases Configure shared servers

Monitoring and Managing Memory

Implement Automatic Memory Management Implement Automatic Shared Memory Management Manually configure SGA parameters for various memory components in the SGA Use Automatic PGA Memory Management

Storage Management

Describe the storage of table row data in blocks Create and manage tablespaces Create and maintain bigfile tablespaces Rename tablespaces Create a default permanent tablespace Relocate SYSAUX occupants

Space Management

Explain how Oracle database server automatically manages space Save space by using compression Proactively monitor and manage tablespace space usage Use the Segment Advisor

Resumable Space Allocation and Segment Shrinking

Manage resumable space allocation Reclaim wasted space from tables and indexes by using the segment shrink functionality

Managing Undo Data

Explain DML and undo data generation Describe the difference between undo data and redo data Monitor and administer undo data Configure undo retention Use automatic undo retention tuning and temporary undo

Managing Data Concurrency

Describe the locking mechanism and how Oracle manages data concurrency Monitor and resolve locking conflicts


Create and manage database user accounts Grant and revoke privileges Create and manage roles Create and manage profiles


Explain DBA responsibilities for security and auditing Enable standard database auditing and unified auditing Enable and configure Unified Audit Data Trail

Automatic Storage Management

Automatic Storage Management Set up initialization parameter files for ASM and database instances Start up and shut down ASM instances Administer ASM diskgroups Set up ASM fast mirror resync Execute SQL commands with ASM file names Use the ASMCMD command-line interface

Backup and Recovery Concepts

Identify the importance of checkpoints, redo log files, and archive log files Configure ARCHIVELOG mode

Configuring Recovery Manager

Create and maintain the Fast Recovery Area Configure database parameters that affect RMAN operations Change RMAN default settings with CONFIGURE Manage RMAN's persistent settings Start the RMAN utility and allocate channels

Basics of Using RMAN to Create Backups

Create backupsets and image copies Create a whole database backup Perform full and incremental backups Enable fast incremental backup Report on and maintain backups

Performing Recovery

Determine the need for performing recovery Perform complete recovery from a critical or noncritical data file loss using RMAN Recover the control file Recover a redo log group member

Loading and Unloading Data

Describe ways to move data Use SQL*Loader to load data from a non-Oracle database Explain Data Pump architecture Use Data Pump export and import Monitor a Data Pump job Use Oracle Data Pump enhancements (in 12c) Create external tables for data population Use SQL*Loader and External table enhancements (in 12c)

Managing Resources

Configure the Resource Manager Assign users to Resource Manager groups Create resource plans within groups Specify directives for allocating resources to consumer groups Monitor the Resource Manager

Proactive Performance Management

Manage the Automatic Workload Repository (AWR) Use the Automatic Database Diagnostic Monitor (ADDM) Describe and use the advisory framework Set alert thresholds Use automated tasks Manage optimizer statistics Use the Memory Advisor to size memory buffers Use the Redo Logfile Size Advisor

Using the SQL Tuning and Access Advisor

Use the SQL Tuning Advisor Use the SQL Access Advisor to tune a workload

Automating Tasks with the Scheduler

Use Oracle Scheduler to simplify management tasks Create a job, program, and schedule Use a time-based or event-based schedule for executing Scheduler jobs Use job chains to perform a series of related tasks Create lightweight jobs Create Windows and Job Classes Use advanced Scheduler concepts to prioritize jobs Use Scheduler jobs on remote systems

Installing Oracle Database 12c

Plan for an Oracle Database software installation Install Oracle Grid Infrastructure for a stand-alone server Install Oracle Database software Use OUI and DBCA for installation and configuration Use Oracle Restart (View the full list of topics on the exam page at All Exams)
Print Friendly, PDF & Email
retour vers le catalogue des formations