Caricamento...
ORA1137

Usare Oracle Enterprise Manager Cloud Control 12c

Prezzo

€ 1,350.00
(Iva esclusa)

Scheda tecnica

Scarica

Giorni

3 gg

Il corso Enterprise Manager Cloud Control 12c è un corso di base. Istruttori esperti vi aiuteranno a esplorare le funzionalità di base di Oracle Enterprise Manager 12c Cloud Control attraverso l'istruzione interattiva e esercizi pratici.

Obiettivi

Al termine del corso gli allievi saranno in grado di:

  • Monitorare la salute generale del sistema Cloud Control
  • Gestire gli obiettivi, gli host e i gruppi
  • Utilizzare il sistema di lavoro per creare e gestire i lavori per automatizzare le attività più comuni
  • Utilizzare Information Publisher per generare report personalizzati
  • Visualizzare, cercare e confrontare le configurazioni
  • Gestire incidenti e distribuzioni
  • Spiegare i criteri di conformità e valutare le violazioni delle policy

Amministratore di Database, Amministratori di Sistema.

Per partecipare con profitto a questo corso è consigliato agli allievi di aver frequentato il corso “Oracle Enterprise Manager 12c Cloud Control: Install & Upgrade”

Enterprise Manager and Other Tools

  • Enterprise Manager

Managing

Managing Backup / Recovery / Flashback and

Online Datafile Move and Automatic Data Optimization

  • Data classification in 12c: tablespace, group, object, row levels
  • Configure heat map
  • Automatic movement and compression
  • Compression levels and types
  • Policy declaration: simple declarative SQL extension
  • Customized automated action execution with user-defined function
  • Execution in scheduled maintenance windows and by MMON
  • Customized schedule with DBMS_ILM package

In-Database Archiving

  • Challenges of old data in tables and 11g solutions
  • In-database archiving new solutions
  • Use ROW ARCHIVAL clause to enable row lifecycle state for applications
  • Set ROW ARCHIVAL VISIBILITY for session level visibility control
  • Use predicate on ORA_ARCHIVE_STATE column
  • Temporal Validity versus Temporal History (Transaction Time of FDA)
  • New clause of CREATE / ALTER TABLE to set a Temporal Validity: PERIOD FOR
  • New SQL temporal data type

Auditing Enhancements

  • Review of 11g R2 audit trail implementation
  • Overview of the Unified Audit Trail
  • Enabling the Unified Audit Trail
  • Creating a separate tablespace for the unified audit trail
  • Granting the AUDIT_ADMIN role to a user for audit trail configuration and management
  • Configuring the Unified Audit Trail to set a tolerance level for loss of audit records
  • Creating audit policies

Privileges Enhancements

  • Implementing Separation of Duty for Database Administration Tasks
  • Using Database Privilege Analysis
  • Overview of Database Privilege Analysis
  • Granting the CAPTURE_ADMIN role to enable management of privilege captures
  • Creating and starting/stopping privilege captures
  • Viewing privilege profile data
  • Querying DBA_PRIV_CAPTURES
  • Using mandatory INHERIT PRIVILEGES privilege to execute invoker's rights procedure

Oracle Data Redaction

  • Overview of Oracle Data Redaction
  • Types of Masking Policies
  • Administering the EXEMPT REDACTION POLICY system privilege to enable a user to view unmasked values
  • Managing Masking Policies
  • Best practices for defining policy expressions
  • Understanding Masking of Statements Containing Subqueries
  • Viewing Information About Masking Policies by Querying REDACTION_POLICIES and REDACTION_COLUMNS

General RMAN New Features and FDA Enhancements

  • Making Database Connections With RMAN
  • Using the SYSBACKUP Privilege
  • Using SQL, DESCRIBE Command, Duplication Operation with the NOOPEN option
  • Backing up and Restoring Very Large Files
  • Creating Multisection Backups
  • Transporting Data Across Platforms
  • Prerequisites and Limitations
  • Transporting Data: Processing steps

Monitoring DB Operations

  • Overview
  • Use cases
  • Current Tools
  • Define a DB operation
  • Monitoring: Bracketing an Operation
  • Monitoring the Progress of Operations
  • DB Operation Tuning
  • DB Operation Active Report

Schema and Data Changes

  • Explain the Schema Change Plan flow
  • Change requests
  • Schema synchronization
  • Explain the Data Comparison flow
  • DBMS_COMPARISON package
  • Guidelines and steps
  • Comparison job and results

SQL Tuning

  • Adaptive Execution Plans
  • SQL Plan Directives
  • Statistics Gathering Performance Improvements
  • Histogram Enhancements
  • Enhancements to Extended Statistics
  • Adaptive SQL Plan Management

Real-Time ADDM and Compare Period Advisor

  • Emergency Monitoring
  • Real time ADDM
  • Use cases
  • Goals
  • Define Workload dimensions
  • Reported items
  • Root Causes
  • Requirements for a report

Resource Manager and Other Performance Enhancements

  • Manage resources between PDBs
  • Manage resources within a PDB
  • Manage resources with CDB and PDBs plans
  • Manage runaway queries
  • Automated maintenance tasks
  • Describe the Multi-process Multi-threaded Oracle architecture
  • Learn how to use this architecture in Oracle 12c Database
  • Demonstrate the changes to shutdown procedures

Index and Table Enhancements

  • Multiple indexes on the same set of columns as long as some characteristic is different
  • Create table with INVISIBLE columns
  • Support for invisible columns
  • Advanced Row Compression
  • Describe online redefinition supports
  • Explain LOCK timeout during FINISH_REDEF_TABLE
  • Using DDL statements in an online manner

ADR and Network Enhancements

  • ADR file types
  • New File types
  • New File locations
  • New commands for ADRCI
  • Improve performance by Compression
  • Setup Compression

Oracle Data Pump, SQL*Loader, External Tables and Online Operations Enhancements

  • Use FULL Transportable export and import
  • Oracle Data Pump enhancements
  • SQL*Loader enhancements
  • SQL*Loader and External table common enhancements
  • SQL*Loader Express Mode usage

Partitioning Enhancements

  • Move a partition online
  • ALTER TABLE ... SPLIT PARTITION, ALTER TABLE ... MERGE PARTITION , ALTER TABLE...ADD PARTITION Clauses: Overview
  • Split Partition Operation Enhancement
  • ALTER TABLE SPLIT SUBPARTITION
  • Merge Partition Operation
  • Add Partition Operation
  • Drop Partition Operation
  • ALTER TABLE DROP SUBPARTITION

SQL Enhancements

  • Enumerate Increase in the length limits for VARCHAR2, NVARCHAR2, and RAW data types in Oracle SQL to 32767 (32k) byte
  • Enumerate miscellaneous enhancements
  • Using SQL Row limiting clause in a query

Gestione multitenant: container

  • Architettura multitenant
  • Root container e pluggable database container
  • Struttura del database contenitore e del plggable db
  • Multitenant in Data Guarf, Golden Gate, Scheduler

Creazione e configurazione CDB e PDB

  • Creazione container, CDB e viste CDB_xxx
  • Creazione PDB fa PDB$SEED
  • Creare un PDB da un’istanza singola
  • Clonare un PDB sotto lo stesso CDB
  • Clonare un PDB soto un CDB diverso
  • Operazioni di plu-in e unplug
  • Start e stop di un PDB o di utti i PDB
  • Shutdown del CDB
  • Creazione tablespace in CDB e PDB
  • Common user

 HEAT MAP e ADO Automatic Data Optimization

  • Configurazione heat map e definizione regole per lo spostamento o compressione
  • Uso del package DBMS_ILM

In-database Archiving

  • ROW ARCHIVAL
  • ROW ARCHIVAL VISIBILITY for session level visibility
  • Temporal Validity versus Temporal History (Transaction Time of FDA)
  • New clause of CREATE / ALTER TABLE to set a Temporal Validity: PERIOD FOR

ASM file, directory

  • Tool di accesso ad ASM File
  • File name format
  • Gestione template di disk group
  • ASM ACL con Command Utilities
  • ASM ACL con Enterpirse  Manager

Gestione ASM Cluster File System

  • ASM Dynamic Volume Manager
  • Gestione ASM Cluster File System (ACFS)
  • ACFS Snapshot

RAC – Real Application Cluster Database

  • installazione
  • creare un cluster database
  • task di post-installazione
  • conversione di instanza singola, rconfig
  • specifici background process per RAC

RAC - amministrazione

  • REDO log in ambiente RAC
  • UNDO tablespace in ambiente RAC
  • Startup e stop di un’istanza RAC
  • Parameteri di inizializzazione

Backup e recovery

  • Parallel Recovery in RAC
  • Gconfigurazione Archivelog
  • Backup in enterprise manager, distribuzione dei backup

Tuning RAC Database

  • Componeneti per il tuning
  • WAIT EVENT specifici per il RAC, Global Enqueue
  • AWR e ADDM per il RAC

Services

  • Definire e gestire servizi in ambiente RAC
  • utilizzare Service in Client Applicatio
  • utilizzare i servizi in Resource Manager
  • utilizzare i servizi conl lo scheduler


Sede Data P
Roma 09/03/2020
Milano 20/04/2020
Bologna 08/06/2020
Roma 22/07/2020
Milano 23/09/2020