Oracle Database 12c New Features
Oracle Database 12c New Features
Attend Live Online Classes, in Real-Time
Discount
$ 450
$ 900
+2 01002934489
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
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.
Learn To:
- Create and manage application containers and applications in multitenant container databases.
- Manage resources in a multitenant container database and pluggable databases with Resource Manager performance profiles and new memory directives.
- Perform pluggable database flashback.
- Upgrade the multitenant container databases and pluggable databases.
- Manage security by using enhancements in unified auditing, system privileges, Privilege Analysis, Data Redaction, Transparent Sensitive Data Protection and Transparent Data Encryption.
- Manage data availability by using Recovery Manager, Oracle Data Pump features and SQL*Loader enhancements, and by performing enhanced online operations.
- Increase the SQL performance by using the In-Memory Column-Store enhancements at deployment and SQL performance.
- Tune the SQL performance by using the Optimizer Statistics Advisor and SQL join processing.
- Monitor your databases by using DB operations enhancements.
- Benefit from enhancements in partitioning methods.
- Benefit from ADR automatic space file management.
- Use the Trace File Analyzer collector to diagnose issues.
- Use the new SQL*Plus history commands and SQL enhancements such as long identifiers.
- Use the new SQLcl utility to benefit from commands and features missing from SQL*Plus itself.
- Describe the Oracle Public Cloud services related to databases management.
Benefits To You
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
- Database Administrators
- System Administrator
- System Administrator
- Support Engineer
- Support Engineer
- Technical Consultant
- 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 from enhancements in partitioning methods
- Use the ADR automatic file space management
- Use the SQLcl new utility as the new SQL command line interface
- Create pluggable databases with new methods and local UNDO mode
- Create and manage application containers and applications in multitenant container databases
- Manage security in application containers
- Manage data optimization in pluggable databases with heat map statistics and ADO policy eviction
- Upgrade pluggable databases and multitenant container databases
- Manage security by using enhancements in unified auditing, system privileges, Privilege Analysis, Data Redaction, Transparent Sensitive Data Protection & Data Encryption
- Manage data availability by using Recovery Manager, Oracle Data Pump features and SQL*Loader enhancements and by performing online operations
- Monitor your databases by using DB operations
- Increase the SQL performance by using In-Memory Column-Store enhancements for deployment and SQL performance
Introduction
- Global objectives of the course
- Lessons grouped by area
- Schedule of the week
Application Containers and Applications
- Upgrade application
- Install application in an application container
- Patch application
- Create and manage an application container
- Application root and application PDBs
- Impacts in Data Guard, Oracle GoldenGate, Oracle Streams, XStream, ADO and Heat Map
Security in PDBs
- Grant privileges commonly, locally in application containers
- Difference between common and local profiles in application containers
- Create users commonly, locally in application containers
- Grant roles commonly, locally in application containers
- Create unified auditing policies operations in application containers
- Difference between common and local roles in application containers
- Difference between common and local objects in application containers
- Manage PDB lockdown profiles
PDBs Creation Using New Methods
- Create a local UNDO tablespace at PDB level
- Create a PDB from CDB seed enhancements
- Create a remote proxy PDB
- Near-zero downtime PDB relocation
- Hot cloning
- Unplug into a PDB archive file and plug using the archive file
PDBs Recovery and Flashback
- Flashback at PDB level
- Flashback a PDB to a clean PDB restore point
- Shut down a PDB when an essential PDB datafile is missing
Performance in PDBs
- View CDB / PDB ADDM analysis
- Share resources between PDBs
- Manage SGA and PGA at the PDB level
Upgrade and Other Operations in PDBs
- Upgrade a 12.1.0.2 CDB to 12.2
- Use cross-platform non-CDB or PDB backupsets to import into a CDB
- Upgrade a 12.1.0.2 PDB to 12.2 by using unplug / plug / upgrade
Privileges and User Profiles
- New 12.2 SYSRAC administrative privilege
- Migrate the password file from pre-12 or 12.1 to 12.2
- Grant administrative privileges to external users
- Pre-configure a maximum number of days in the user profile for which a user can remain inactive
- Enhance the security of administrative users
- New system privilege INHERIT ANY REMOTE PRIVILEGES and object privilege INHERIT REMOTE PRIVILEGES
- Password file enhancements
Unified Auditing
- Capture VPD (Virtual Private Database) generated predicates
- Create and enable audit policies for all users to whom the role is granted directly
Data Redaction
- New redaction functions
- Redaction policy expression
- New redaction format library in EM GUI
Data Encryption
- Complete the operations with ALTER TABLESPACE ENCRYPTION FINISH ENCRYPT|REKEY|DECRYPT
- Encrypt / decrypt / rekey tablespaces online
- Specific tablespaces: SYSAUX, SYSTEM, UNDO and temporary
Transparent Sensitive Data Protection
- Use TSDP with Fine-Grained Auditing (FGA)
- Use TSDP with Transparent Data Encryption (TDE)
- Use TSDP with Unified Auditing
Availability Enhancements
- Non auto-login support for duplicate: Use encrypted backups whose decryption keys are in a non auto-login wallet
- Update and drop the catalog without entering the UPGRADE CATALOG and DROP CATALOG commands twice: UPGRADE / DROP CATALOG NOPROMPT
- REPAIR FAILURE command
- Automate the two step manual process into one recovery operation after missing logs found during RECOVER DATABASE: Recover Database Until Available Redo
- Transport Data Across Platforms
- Describe online redefinition supports
- Steps to recover a table
Oracle Data Pump, SQL*Loader and External Tables
- SQL*Loader enhancements
- Oracle Data Pump enhancements
- External table enhancements
In-Memory Column Store
- Interaction with other products, features
- Optimizing joined columns by creating join groups
- Caches results of frequently evaluated expressions and virtual columns for subsequent reuse
- Dynamic parameter in 12.2 : INMEMORY_SIZE
SQL Tuning
- New ways of SQL processing
- SQL Performance Analyzer enhancements
- Statistics Gathering Performance Improvements: Optimizer Statistics Advisor
- SQL Performance Analyzer (SPA) enhancements to make it resilient to certain workloads which can cause divergence
- Continuous Adaptive Query Plans
- SQL Plan Management enhancements
Resource Manager and Other Performance Enhancements
- 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
- Reduce Cursor Invalidations for DDLs
- Describe the Advanced Index Compression (HIGH)
- Describe HCC data compression with ADO row-level policy
- Manage session PGA limit
Partitioning
- Filter data during partition maintenance operations
- Explain auto-list partitioning
- Defer subpartition segment creation
- Explain multicolumn list partitioning
- Composite partitioning
- Read-only partition
Manageability
- Start / stop a DBOP by specifying the Session ID and Serial#
Diagnosability
- MV refresh statistics
- Set a retention target to ADR for an automatic delete of ADR files
- Install TFA Collector by default for RDBMS (with RDBMS root scripts)
- Allow Data Pump tracing to be changed without stopping and then restarting the job
- Start TFA Collector
- Use the retention advisor
Oracle Database Cloud Services
- Database deployment backup and recovery automatic procedures
- Create a database deployment under 12.2
- Migrate on-premises database to Oracle Database Public Cloud Services
- Describe the Oracle Database Cloud Services console
- Differences between database deployments and on-premises databases
SQL Enhancements
- Use the new VALIDATE_CONVERSION function
- Describe the new SQLcl utility
- Recall SQL*Plus commands in the same session from memory
- Use new 128 bytes length for database objects
|
|
Join us 
Join us |
register
* All fields are required