*Friday CLOSED

Timings 10.00 am - 08.00 pm

Call : 021-3455-6664, 0312-216-9325 DHA 021-35344-600, 03333808376, ISB 03333808376

Oracle Database 12c R2: New Features for 12c R1 Administrators


Be the first to rate Oracle Database 12c R2: New Features for 12c R1 Administrators
Or log in to access your purchased courses
by admin2
Price: 80,000
5 Days
0 Lessons

New Feature 12c R1 Course

COURSE DESCRIPTION

Oracle Database 12c R2: New Features for 12c R1 Administrators

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.


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.


Course Content:

Introduction

Global objectives of the course
Lessons grouped by area
Schedule of the week


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


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
Manage PDB lockdown profiles
Create unified auditing policies operations in application containers


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


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


Performance in PDBs

View CDB / PDB ADDM analysis
Manage SGA and PGA at the PDB level
Share resources between PDBs


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


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


Unified Auditing

Create and enable audit policies for all users to whom the role is granted directly
Capture VPD (Virtual Private Database) generated predicates


Data Redaction

New redaction format library in EM GUI
Redaction policy expression
New redaction functions


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


Transparent Sensitive Data Protection

Use TSDP with Unified Auditing
Use TSDP with Fine-Grained Auditing (FGA)
Use TSDP with Transparent Data Encryption (TDE)


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
Automate the two step manual process into one recovery operation after missing logs found during RECOVER DATABASE: Recover Database Until Available Redo
REPAIR FAILURE command
Transport Data Across Platforms
Steps to recover a table
Describe online redefinition supports


Oracle Data Pump, SQL*Loader and External Tables

Oracle Data Pump enhancements
SQL*Loader enhancements
External table enhancements


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


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


Resource Manager and Other Performance Enhancements

Manage session PGA limit
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


Partitioning

Explain auto-list partitioning
Composite partitioning
Explain multicolumn list partitioning
Read-only partition
Defer subpartition segment creation
Filter data during partition maintenance operations


Manageability

Start/stop a DBOP by specifying the Session ID and Serial#


Diagnosability

Set 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


Oracle Database Cloud Services

Describe the Oracle Database Cloud Services console
Create a database deployment under 12.2
Database deployment backup and recovery automatic procedures
Differences between database deployments and on-premises databases
Migrate on-premises database to Oracle Database Public Cloud Services


SQL Enhancements

Describe the new SQLcl utility
Use new 128 bytes length for database objects
Recall SQL*Plus commands in the same session from memory
Use the new VALIDATE_CONVERSION function


Training Track: Database


Job Interview Preparation  (Soft Skills Questions & Answers)


 Your FREE eLEARNING Courses (Click Here)

Internships, Freelance and Full-Time Work opportunities


Flexible Class Options

  • Week End Classes For Professionals  SAT | SUN
  • Corporate Group Trainings Available
  • Online Classes – Live Virtual Class (L.V.C), Online Training

Related Oracle Courses

Oracle Database 12C RAC Administration

Oracle JAVA Cloud Service Certified

Oracle DBA 12C SQL Database Fundamentals Course


KEY FEATURES

Flexible Classes Schedule

Online Classes for out of city / country students

Unlimited Learning - FREE Workshops

FREE Practice Exam

Internships Available

Free Course Recordings Videos

Register Now

Lessons

Or log in to access your purchased courses
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.
ABOUT US

OMNI ACADEMY & CONSULTING is one of the most prestigious Training & Consulting firm, founded in 2010, under MHSG Consulting Group aim to help our customers in transforming their people and business - be more engage with customers through digital transformation. Helping People to Get Valuable Skills and Get Jobs.

Read More

Contact Us

Get your self enrolled for unlimited learning 1000+ Courses, Corporate Group Training, Instructor led Class-Room and ONLINE learning options. Join Now!
  • Head Office: A-2/3 Westland Trade Centre, Shahra-e-Faisal PECHS Karachi 75350 Pakistan Call 0213-455-6664 WhatsApp 0334-318-2845, 0336-7222-191, +92 312 2169325
  • Gulshan Branch: A-242, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, Karachi-75300, Call/WhatsApp 0213-498-6664, 0331-3929-217, 0334-1757-521, 0312-2169325
  • ONLINE INQUIRY: Call/WhatsApp +92 312 2169325, 0334-318-2845, Lahore 0333-3808376, Islamabad 0331-3929217, Saudi Arabia 050 2283468
  • DHA Branch: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 0213-5344600, 0337-7222-191, 0333-3808-376
  • info@omni-academy.com
  • FREE Support | WhatsApp/Chat/Call : +92 312 2169325
WORKING HOURS

  • Monday10.00am - 7.00pm
  • Tuesday10.00am - 7.00pm
  • Wednesday10.00am - 7.00pm
  • Thursday10.00am - 7.00pm
  • FridayClosed
  • Saturday10.00am - 7.00pm
  • Sunday10.00am - 7.00pm
WhatsApp Us