Oracle Database 12c Administration

Bu eğitim, Oracle veritabanının yönetimi konusunda sağlam bir temel oluşturulması için tasarlanmıştır. Katılımcılar bu eğitimde, Oracle Veritabanı mimarisi ile ilgili kavramsal bilgiler edinirken, Oracle Veritabanının nasıl etkili ve verimli bir şekilde yönetileceğini öğrenirler.


Bu eğitimde neler öğreneceksiniz?



  • Oracle Veritabanı sunucusunu yönetme
  • Oracle Ağ ortamını yapılandırma
  • Depolama yapılarını oluşturma ve yönetme
  • Veri yönetimi ve verileri taşıma.
  • Kullanıcı oluşturma ve kullanıcıları yönetme.
  • Veritabanı izleme ve performans yönetimi.
  • Database as a Cloud Service (Bulut Hizmeti olarak Veritabanı) veritabanı dağıtımları oluşturma ve yönetme

Overview of Oracle Database 12

Configuring the instance and database

•Balancing user requirements and resources

•Ensuring database availability

Conceptualizing the Oracle 12c architecture

•Processing transactions with the Oracle 12c server

•Identifying types of processes, memory structures and files


Constructing an Oracle 12

Creating the database

•Automating memory allocation with memory targets

•Establishing network connectivity

•Setting up control files and online redo log files


Starting and stopping the database

•Mounting and opening the database

•Authenticating connections having SYSDBA privilege


Automating administration with Oracle Enterprise Manager (OEM) Cloud Control 12

Evaluating the OEM architecture

•Navigating the graphical interface

•Comparing command-line and graphical techniques


Maintaining the database with OEM Cloud Control 12c

•Setting thresholds and generating alerts

•Managing privileges and roles

•Evaluating container and pluggable databases


Flashing Back Oracle 12

Configuring UNDO tablespaces

•Setting UNDO retention targets

•Switching to an alternative UNDO tablespace


Monitoring and reversing changes to data

•Tracking changes to data values with row history

•Backing out user errors with Flashback Table

•Retrieving dropped tables from the recycle bin

•Implementing the Valid Time support feature


Managing Users and Resources

Establishing user accounts

•Authenticating users with Oracle 12c password validation

•Allocating space quotas and limiting resource usage


Enforcing security

•Granting and revoking system and object privileges

•Simplifying privilege management with roles

•Capturing the use of privileges with dbms_privilege_capture


Performing Space Management

Building the storage hierarchy

•Configuring tablespaces and datafiles

•Handling sort data with temporary tablespaces

•Creating Oracle Managed Files

Structuring data and index segments

•Managing extents, blocks and large objects (LOB) storage

•Eliminating row migration with PCTFREE and Data Pump

•Conserving storage by compressing table data

•Regaining space by shrinking tables and indexes online


Partitioning for Performance and Administration

Creating partitioned and subpartitioned tables

•Evaluating range, list and hash partitioning methods

•Administering partitions with merge, split, add and drop

•Deploying partitioned tables based on virtual columns and referenced tables


Maintaining index partitions

•Comparing the performance and maintenance of local and global indexes

•Monitoring index partitions and rebuilding unusable indexes

•Limiting indexing of partitions with partial indexing


Building a Fault-Tolerant Database

Safeguarding the database

•Role of the redo log and control file

•Ensuring recovery using archiving

•Protecting and tracing the control file


Backing up the database and performing recovery

•Implementing user-managed hot and cold backups

•Restoring and recovering the entire database

•Recovering corrupted tablespaces

•Managing logical errors with flashback transaction back out


A working knowledge of SQL and PL/SQL packages is very helpful in the course. Basic knowledge of Linux operating system

Eğitim Detayları
Süre 5 Gün
Kontenjan Max 12 Kişi
Eğitim Tipi Sınıf / Sanal Sınıf


Aradığınızı bulamadınız mı? Bize ulaşın, yardımcı olalım!

İletişim