Oracle Database 12c: New Features for Administrators Seminar

Die Trainings-Schwerpunkte werden nach Ihrem persönlichen Beratungsgespräch festgelegt. In diesem Oracle Training sind folgende Themen vorgesehen: Enterprise Manager and Other Tools - Enterprise Manager (EM) Cloud Control home page - Enterprise Manager Express home page versus Enterprise Manager Database Control - SQL Developer with new functionalities - OUI, DBCA Basics of Multitenant Container Database (CDB) - Benefits of the multitenant architecture - Differences between the root container and pluggable database containers - Structure of the root - Structure of Pluggable Database (PDB) - CDB_xxx and DBA_xxx views - Impacts in Security, Data Guard, Oracle GoldenGate, Oracle Streams, XStream, and Scheduler Configuring and Creating CDB and PDBs - Tools: DBCA and SQL*Plus - Configuration and creation of CDB - Exploring the Structure (CDB_xxx views and EM) - Tools used: SQL Developer, DBCA and SQL*Plus - Create a new PDB from PDB$SEED - Create a PDB from a non-CDB - Clone a PDB into the same CDB or into another CDB using DB links - Plug in an unplugged PDB Managing CDB and PDBs - Connect to CDB as administrator - Connect to a PDB using a service name - Start up a CDB - Open / Close a PDB (SQL*Plus, srvctl, EM) - Open / Close all PDBs - Shut down a CDB - Triggers ON PLUGGABLE DATABASE - Change PDB state Managing Tablespaces, Common and Local Users, Privileges and Roles - Create permanent tablespaces in the root and PDBs - Manage common and local schemas and users in the root and PDBs - Manage system and object privileges to common and local grantees granted "commonly" or "locally" - Manage common and local roles granted "commonly" or "locally" Managing Backup / Recovery / Flashback and Migration - Backup a whole CDB - Backup a PDB - Recover CDB from redo log files, control files, undo datafiles loss - Recover PDB from PDB datafiles loss - Flashback at CDB level 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 - 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