Oracle Database 12c New Features for Administrators

Changes to Database Management Tools

• Enterprise Manager Cloud Control Home Page
• Enterprise Manager Express Home Page
• SQL Developer new functionality
• Changes to the OUI and the DBCA

Oracle Database 12c Architecture

• Overview of the Oracle database architecture
• An overview of a Container Database (CDB)
• The benefits of Multitenant Architecture
• The root container and Pluggable Database containers
• The structure of the Root Container
• The structure of a Pluggable Database (PDB)
• CDB_xxx and DBA_xxx Views

Create a Database with the Database Configuration Assistant (DBCA)

• Select a database storage method
• Select a CDB or non-CDB database
• Select a database type based on workload
• Select a character set for the database
• Set the NLS_LANG initialization parameter
• Create a database with the DBCA

Preparation for Upgrade to Oracle Database 12c

• Methods used to perform upgrade
• Methods of data migration
• Direct upgrade supported releases
• Upgrade process overview
• Rolling upgrade
• Upgrade a CDB
• Create an upgrade test plan
• Carry out performance testing
• Run the Pre-Upgrade Information tool
• Backup the database
• Install the Oracle Database 12c software
• Create the new Oracle home

Perform an Upgrade to Oracle Database 12c

• Upgrade a database with the Database Upgrade Assistant (DBUA)
• Upgrade a database manually
• Migrate a non-CDB to a CDB

Post Upgrade Tasks

• Carry out post upgrade tasks after a manual upgrade
• Migrate to unified auditing

Migrate Data with Data Pump

• Migrate data with Data Pump
• Import data using a Data Pump network link

Configure and Create a Container Database and Pluggable Databases

• Create and configure a CDB using Enterprise Manager
• Examine the structure of a CDB using Enterprise Manager and the CDB_xxx Views
• Administer the database using Enterprise Manager and SQL*Plus
• Create a new PDB from PDB$SEED
• Create a PDB from a Non-CDB
• Clone a PDB into the same CDB using DB links
• Plug in an Unplugged PDB

Manage a Container Database and Pluggable Databases

• Connect to a CDB as an Administrator
• Connect to a PDB using a service name
• Startup and shutdown a CDB
• Open and close a PDB Using SQL*Plus and EM
• Open and close all PDBs
• Change the state of a PDB

New Tablespaces and Management Features

• Data storage overview
• Create permanent tablespaces in the root and PDBs
• Online rename and relocation of an active datafile
• Restrict PGA size
• Implement extended data types for VARCHAR2, NVARCHAR2 and RAW data types to 32767 bytes
• Temporary UNDO
• DDL Logging

Manage Common and Local Users, Roles and Privileges

• Manage common and local schemas and users in the Root and PDBs
• Manage system and object privileges to common and local grantees
• Manage common and local roles

Manage Back-Up, Recovery and Flashback of a CDB and PDB

• Backup a CDB
• Backup a PDB
• Recover a CDB from the loss of redo log files, control files and undo datafile loss
• Recover a CDB from the loss of datafiles
• Use Flashback at CDB Level

On-Line Datafile Move and Automatic Data Optimisation

• Data classification in 12c
• Configure a heat map
• Automatic movement and compression
• Compression levels and types

In Database Archiving

• New In-database archiving solutions
• Use the ROW ARCHIVAL clause to enable row lifecycle state for applications
• Set the ROW ARCHIVAL VISIBILITY for session level visibility control
• Use predicate on ORA_ARCHIVE_STATE column
• Set a Temporal Validity: PERIOD FOR with the CREATE or ALTER TABLE clause
• SQL temporal data type

Enhancements to Database Auditing

• Overview of database security
• Overview of database auditing in Oracle Database 12c
• Security compliance
• Standard auditing
• Unified audit trail overview
• Create a tablespace for the Unified Audit Trail
• Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles
• Configure the Unified Audit Trail
• Specify audit options
• Configure the Unified Audit Trail to set a tolerance level for lost of audit records
• Create audit policies

Enhancements and Privileges

• Implement the separation of duties for Database Administration tasks
• An overview of Database Privilege Analysis
• Grant the CAPTURE_ADMIN role to enable management of privilege captures
• Create, start and stop privilege captures
• Viewing privilege profile data
• Query the DBA_PRIV_CAPTURES view
• Use the mandatory INHERIT PRIVILEGES privilege to execute the invoker's rights procedure

Data Redaction

• Overview of Oracle Data Redaction
• Types of data masking policies
• Administer the EXEMPT REDACTION POLICY system privilege to enable a user to view unmasked values
• Manage masking policies
• Understanding the masking of statements containing subqueries
• Query the data dictionary to obtain information on masking policies

New RMAN Features

• The SYSBACKUP privilege
• Execute SQL statements in RMAN
• Use the RMAN DESCRIBE Command
• Table or partition recovery
• Restore and recover datafiles across the network
• Run the duplicate operation with the NOOPEN option
• Backup and restore very large files
• Cross platform backup and restore

Monitoring Database Operations

• Overview of DB monitoring operations
• Define a DB operation
• Bracketing an operation
• Monitoring the progress of operations
• DB Operation tuning
• DB Operation Active report

Schema and Data Changes

• Create identity columns
• Create a table with invisible columns
• Set default values for table columns
• Truncate table cascade
• Session lavel sequences
• Create multiple indexes on the same set of columns
• Advanced Row Compression
• The Schema Change Plan flow
• Change requests
• Schema synchronization
• The Data Comparison flow
• The DBMS COMPARISON package
• Comparison job and results

SQL and PL/SQL Enhancements

• SQL*Plus Enhancements
• Last login time
• Row limiting for Top-N result Queries
• The Schema Change Plan flow
• PL/SQL Enhancements
• Implicit results on SQL*Plus
• WITH clause enhancements

Performance Tuning New Features

• Partitioning Enhancements
• Data Pump Single-Partition Imports
• Materialized Views and Query Rewrite Enhancements
• The PIVOT and UNPIVOT Clauses
• Data Compression
• Enhancements to the Degree of Parallelism
• In Memory Parallel Query
• System Managed Indexes for List Partitioning
• Overview of new ADDM Analysis features
• Emergency Monitoring
• Real time ADDM analysis
• Define Workload dimensions
• Reported items
• Root causes
• Report requirements

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

ADR and Network Support

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

Data Pump and SQL*Loader Enhancements

• Data Pump enhancements
• Turn off redo log generation
• Transport view as table
• Use FULL Transportable export and import
• SQL*Loader enhancements
• SQL*Loader and External table common enhancements
• SQL*Loader Express

Partitioning Enhancements

• Move a partition online
• An overview of the ALTER TABLE ... SPLIT PARTITION, ALTER TABLE ... MERGE PARTITION , ALTER .TABLE...ADD PARTITION clauses
• The split partition operation enhancement
• The merge partition operation
• The Add and drop partition operations