Курс: Oracle Database 12c R2: New Features for 12c R1 Administrators

Курс: Oracle Database 12c R2: New Features for 12c R1 Administrators

Курс: Oracle Database 12c R2: New Features for 12c R1 Administrators


Продолжительность курса: 40 ак. ч.

Описание курса:
The Oracle Database 12c R2: New Features for 12c R1 Administrators course is designed for existing 12c Release 1 DBAs. In addition to covering the New Features of R2, this course also introduces students to the Oracle Database Cloud Service. In the lessons, you learn the new and enhanced features of Oracle Database 12c Release 2 (12.2.0.1) amongst different areas such as Multitenant, security, availability, performance, diagnosability, manageability, partitioning and SQL. You also learn how to easily deploy databases with Oracle Database Cloud Services, check automated backups and monitor your Cloud deployment with new Cloud tools.

Аудитория:
•    Database Administrators
•    Support Engineer
•    System Administrator
•    Technical Consultant

Необходимая подготовка:
•    Knowledge of Oracle Database 12c and particularly 12.1.0.2
•    Oracle Database 12c R1: New Features for Administrators Ed 2

Результат обучения:
После изучения курса слушатель будет уметь:
•    Perform recovery and flashback operation on pluggable databases
•    Monitor multitenant container database and pluggable databases by using ADDM / AWR enhancements at PDB level Manage resources in a multitenant container database and pluggable databases with Resource Manager performance profiles
•    Tune the SQL performance by using the Optimizer Statistics Advisor and SQL join processing
•    Benefit fr om enhancements in partitioning methods
•    Use the ADR automatic file space management

Программа курса:
Модуль 1. Introduction
•    Global objectives of the course
•    Lessons grouped by area
•    Schedule of the week

Модуль 2. Application Containers and Applications
•    Application root and application PDBs
•    Create and manage an application container
•    Install application in an application container
•    Patch application
•    Upgrade application
•    Impacts in Data Guard, Oracle GoldenGate, Oracle Streams, XStream, ADO and Heat Map

Модуль 3. Security in PDBs
•    Create users commonly, locally in application containers
•    Grant privileges commonly, locally in application containers
•    Difference between common and local roles in application containers
•    Grant roles commonly, locally in application containers
•    Difference between common and local objects in application containers
•    Difference between common and local profiles in application containers

Модуль 4. PDBs Creation Using New Methods
•    Create a PDB from CDB seed enhancements
•    Unplug into a PDB archive file and plug using the archive file
•    Create a local UNDO tablespace at PDB level
•    Hot cloning
•    Near-zero downtime PDB relocation
•    Create a remote proxy PDB

Модуль 5. PDBs Recovery and Flashback
•    Shut down a PDB when an essential PDB datafile is missing
•    Flashback at PDB level
•    Flashback a PDB to a clean PDB restore point

Модуль 6. Performance in PDBs
•    View CDB / PDB ADDM analysis
•    Manage SGA and PGA at the PDB level
•    Share resources between PDBs

Модуль 7. Upgrade and Other Operations in PDBs
•    Upgrade a 12.1.0.2 CDB to 12.2
•    Upgrade a 12.1.0.2 PDB to 12.2 by using unplug / plug / upgrade
•    Use cross-platform non-CDB or PDB backupsets to import into a CDB

Модуль 8. Privileges and User Profiles
•    New 12.2 SYSRAC administrative privilege
•    Password file enhancements
•    Grant administrative privileges to external users
•    Migrate the password file from pre-12 or 12.1 to 12.2
•    New system privilege INHERIT ANY REMOTE PRIVILEGES and object privilege INHERIT REMOTE PRIVILEGES
•    Enhance the security of administrative users
•    Pre-configure a maximum number of days in the user profile for which a user can remain inactive

Модуль 9. Unified Auditing
•    Create and enable audit policies for all users to whom the role is granted directly
•    Capture VPD (Virtual Private Database) generated predicates

Модуль 10. Data Redaction
•    New redaction format library in EM GUI
•    Redaction policy expression
•    New redaction functions

Модуль 11. Data Encryption
•    Encrypt / decrypt / rekey tablespaces online
•    Specific tablespaces: SYSAUX, SYSTEM, UNDO and temporary
•    Complete the operations with ALTER TABLESPACE ENCRYPTION FINISH ENCRYPT|REKEY|DECRYPT

Модуль 12. Transparent Sensitive Data Protection
•    Use TSDP with Unified Auditing
•    Use TSDP with Fine-Grained Auditing (FGA)
•    Use TSDP with Transparent Data Encryption (TDE)

Модуль 13. Availability Enhancements
•    Non auto-login support for duplicate: Use encrypted backups whose decryption keys are in a non auto-login wallet
•    Upd ate and drop the catalog without entering the UPGRADE CATALOG and DROP CATALOG commands twice: UPGRADE / DROP CATALOG NOPROMPT
•    Automate the two step manual process into one recovery operation after missing logs found during RECOVER DATABASE: Recover Database Until Available

Модуль 14. Redo
•    REPAIR FAILURE command
•    Transport Data Across Platforms
•    Steps to recover a table
•    Describe online redefinition supports

Модуль 15. Oracle Data Pump, SQL*Loader and External Tables
•    Oracle Data Pump enhancements
•    SQL*Loader enhancements
•    External table enhancements

Модуль 16. In-Memory Column Store
•    Dynamic parameter in 12.2 : INMEMORY_SIZE
•    Caches results of frequently evaluated expressions and virtual columns for subsequent reuse
•    Optimizing joined columns by creating join groups
•    Interaction with other products, features

Модуль 17. SQL Tuning
•    SQL Performance Analyzer enhancements
•    SQL Plan Management enhancements
•    Statistics Gathering Performance Improvements: Optimizer Statistics Advisor
•    SQL Performance Analyzer (SPA) enhancements to make it resilient to certain workloads which can cause divergence
•    New ways of SQL processing
•    Continuous Adaptive Query Plans

Модуль 18. Resource Manager and Other Performance Enhancements
•    Manage session PGA lim it
•    Reduce Cursor Invalidations for DDLs
•    Describe the Advanced Index Compression (HIGH)
•    Define real-time materialized views with on query computation
•    Use ON STATEMENT refresh when a DML operation takes place on materialized views without the need to committhe transaction
•    Describe HCC data compression with ADO row-level policy

Модуль 19. Partitioning
•    Explain auto-list partitioning
•    Composite partitioning
•    Explain multicolumn list partitioning
•    Read-only partition
•    Defer subpartition segment creation
•    Filter data during partition maintenance operations

Модуль 20. Manageability
•    Start / stop a DBOP by specifying the Session ID and Serial#

Модуль 21. Diagnosability
•    Se t a retention target to ADR for an automatic delete of ADR files
•    Use the retention advisor
•    Install TFA Collector by default for RDBMS (with RDBMS root scripts)
•    Start TFA Collector
•    Allow Data Pump tracing to be changed without stopping and then restarting the job
•    MV refresh statistics

Модуль 22. Oracle Database Cloud Services
•    Describe the Oracle Database Cloud Services console
Записаться на курс

Характеристики курса

  • Начало: Ведется набор
  • Вендор: Oracle
  • Код курса: OracleIDS23
  • Город: Екатеринбург, Пермь, Челябинск, Самара, Ижевск,
  • Направление: Oracle iPlatform: Database Server
  • Академических часов: 40
  • Количество мест: 8
  • Очно: 102900 ₽
  • Дистанционно: 102900 ₽
Записаться на курс

Курсы повышения квалификации
и профессиональной переподготовки


График работы:
Мы отвечаем на звонки и письма в будние дни с 7:00 до 16:00 по Мск

Юридический адрес организации:
614010, г. Пермь, ул. Клары Цеткин, д. 14, офис 32

8 800 (600)-66-16

learning@eshift.ru