Oracle12c -18c New Features For Administrators (Five Days)

Course:   OR18NEW
Duration:   5 Days
Level:   I
On our website at:   http://www.verhoef-training.com/courses/OR18NEW.html
 
Course Summary

This course provides a complete, hands-on introduction to the newest releases of Oracle Enterprise Edition. Key features of this product are fully discussed and demonstrated.

Topics Covered In This Course

CHAPTER 1 SQL ENHANCEMENTS

MAJOR ENHANCEMENTS

TOP N AND BOTTOM N QUERIES

USING EXTENDED DATATYPES

CONCURRENT UNION / UNION ALL EXECUTION

SEQUENCES WITH DEFAULT VALUES

SEQUENCES WITH GLOBAL TEMPORARY TABLES

IDENTITY COLUMNS

NEW SEQUENCE FUNCTIONALITY FOR ORACLE REPLAY

INVISIBLE COLUMNS

TEMPORAL VALIDITY

PATTERN MATCHING

DATA VALIDATION

DATA-BOUND COLLATION

SETTING COLLATION AT THE SCHEMA LEVEL

SETTING COLLATION AT THE TABLE AND COLUMN LEVELS

SETTING COLLATION FOR VIEWS USING COLLATE

SPECIFYING COLLATION FOR AN EXPRESSION

CASE-INSENSITIVE DATABASE

UNICODE 7.0 SUPPORT

MISCELLANEOUS NEW SQL FEATURES

THEY BROKE LOGIN.SQL!

DATA MODEL REVIEW

LAB 1: SQL ENHANCEMENTS

LAB 1 SOLUTIONS: SQL ENHANCEMENTS ?

CHAPTER 2 PL/SQL ENHANCEMENTS

WHITE LISTS

THE WITH CLAUSE FOR FUNCTIONS

PRAGMA UDF

NEW INQUIRY DIRECTIVES

NEW DBMS_SQL FUNCTIONALITY

ENHANCED LANGUAGE INTERFACE FEATURES

THE IMPACT OF DATA-BOUND COLLATION

NEW VIEWS FOR USE WITH PL/SCOPE

MISCELLANEOUS NEW PL/SQL FEATURES FOR ORACLE12C

LAB 2: PL/SQL ENHANCEMENTS

LAB 2 SOLUTIONS: PL/SQL ENHANCEMENTS ?

CHAPTER 3 INSTALLATION / UPGRADING

OVERVIEW OF DATABASE CREATION

IN THE BEGINNING

THE ORACLE UNIVERSAL INSTALLER

PREREQUISITE TASKS

MEMORY REQUIREMENTS

HARDWARE REQUIREMENTS

SOFTWARE REQUIREMENTS

PACKAGE REQUIREMENTS

WHAT ABOUT WINDOWS?

RUNNING THE INSTALLER

POST INSTALLATION

ENVIRONMENT

USING THE DATABASE CONFIGURATION ASSISTANT

USING THE DATABASE CONFIGURATION ASSISTANT SHORT FORM

DATABASE TEMPLATES

UPGRADING THE DATABASE

USING THE COMPATIBLE PARAMETER

DATABASE CONTROL REMOVAL

UPGRADE PREREQUISITES

TIME WARP FROM CHAPTER 8

REMOVING ORACLE SOFTWARE

LAB 3: INSTALLATION / UPGRADING

LAB 3 SOLUTIONS: INSTALLATION / UPGRADING ?

CHAPTER 4 ENTERPRISE MANAGER ENHANCEMENTS

DATABASE MANAGEMENT USING EMDE

ENVIRONMENTAL VARIABLES

ACCESSING ENTERPRISE MANAGER DATABASE EXPRESS

MODIFIED FUNCTIONALITY WITH EMDE

CHANGING PARAMETERS

MODIFICATION OF PHYSICAL STRUCTURES

DELETED FUNCTIONALITY IN EMDE

DATABASE ADMINISTRATION WITH OTHER TOOLS

EMDE ACCESS FOR NON-DBA USERS

EMDE ACCESS TO PLUGGABLE DATABASES/

LAB 4: ENTERPRISE MANAGER ENHANCEMENTS

LAB 4 SOLUTIONS: ENTERPRISE MANAGER ENHANCEMENTS ?

CHAPTER 5 SQL DEVELOPER / SQL*PLUS

SQL DEVELOPER NEW FEATURES

INSTANCE VIEWER

MULTITENANT CONNECTION CONSIDERATIONS

USING SQL DEVELOPER

SQL*PLUS FOR ORACLE12C

NEW SHOW COMMANDS

LAST LOGIN TIME

SUPPORT FOR THE NEW ADMINISTRATIVE PRIVILEGES

SUPPORT FOR PLUGGABLE DATABASES

WE HAVE HISTORY! (R2)

PERFORMANCE SETTINGS (R2)

CSV OPTION FOR MARKUP (R2)

FEEDBACK ONLY (R2)

SUPPORT FOR LONG IDENTIFIERS (R2)

APPLICATION CONTINUITY FLAG (R2)

INPUT BINDING (R2)

A BRIEF WORD ON SQL DEVELOPER 17.2

LAB 5: SQL DEVELOPER / SQL*PLUS

LAB 5 SOLUTIONS: SQL DEVELOPER / SQL*PLUS

CHAPTER 6 ? MULTITENANT DATABASES

THE IMPACT OF MULTITENANT ARCHITECTURE

MAJOR BENEFITS OF MULTITENANT ARCHITECTURE

THE BIRD?S EYE VIEW

WALKING THE DIRECTORIES OF A CONTAINER DATABASE

WHO? WHAT? WHEN? WHERE? HOW?

IMPACTS OF MULTITENANT ARCHITECTURE

TOOLS FOR USE WITH MULTITENANT ARCHITECTURE

SQL*Plus

DBCA

Oracle Enterprise Manager Cloud Control

SQL Developer

Service Control (SRVCTL)

LAB 6: MULTITENANT DATABASES

LAB 6 SOLUTIONS: MULTITENANT DATABASES ?

CHAPTER 7 MULTITENANT BASICS

CREATING CDBS

FEATURES UNSUPPORTED FOR MULTITENANT ARCHITECTURE

THE CREATE DATABASE COMMAND FOR CDBS

SEED DATA FILES

CONFIGURING ENTERPRISE MANAGER DATABASE EXPRESS FOR CDBS

USING SQL DEVELOPER WITH CDBS AS A DBA

LAB 7: MULTITENANT BASICS

LAB 7 SOLUTIONS: MULTITENANT BASICS ?

CHAPTER 8 INTERMEDIATE MULTITENANT

OPTIONS AVAILABLE

THE CREATE PLUGGABLE DATABASE STATEMENT

The STORAGE Clause

File Locations Clause

Temp File Clause

PREPARING TO CREATE PDBS

CREATING PDBS USING THE CDB SEED

Specifics Using SQL*Plus

CLONING AN EXISTING LOCAL PDB

Specific Cloning Steps

CLONING AN EXISTING REMOTE PDB

Specific Cloning Steps

Effects Of Cloning A Remote PDB

HOT CLONING

REFRESHABLE PDBS

UNPLUGGING A PDB

CREATING A PDB BY PLUGGING IN AN UNPLUGGED PDB

ENHANCEMENTS TO UNPLUG/PLUG IN RELEASE 2

CREATING A PDB FROM A NON-CDB DATABASE

Using DBMS_PDB

HOT CLONING NON-CDBS

PDB RELOCATE

NEW TRIGGER TYPES FOR PDBS

The BEFORE UNPLUG Trigger

The AFTER CLONE Trigger

LAB 8: INTERMEDIATE MULTITENANT

LAB 8 SOLUTIONS: INTERMEDIATE MULTITENANT ?

CHAPTER 9 ADVANCED MULTITENANT

USING DATA PUMP EXPORT AND IMPORT

USING EXP AND IMP

DROPPING PDBS

USING CLOUD CONTROL TO CREATE AND DROP PDBS

ADMINISTRATION DETAILS

SPECIAL ROLES FOR CDBS

OTHER ADMINISTRATIVE CONSIDERATIONS FOR CDBS

MANAGEABILITY CONSIDERATIONS

OBJECTS IN CDBS

SERVICES

SESSIONS

COMMON LISTENERS

CONNECTING TO PDBS IN MOUNT MODE

LOGIN TRIGGERS AND THE SET CONTAINER CLAUSE

PACKAGE STATES AND CONTAINERS

EXECUTE IMMEDIATE AND SET CONTAINER

EXECUTING ACROSS ALL PLUGGABLE DATABASES USING DBMS_SQL

LOGGING ERRORS FOR MULTIPLE CONTAINERS

ALTER DATABASE IN A CDB

TABLESPACES IN CDBS

USING FORCE ON PDBS

CLOSE VS. CLOSE IMMEDIATE

SPECIFYING PDBS IN ALTER PLUGGABLE DATABASE

DEFAULT AND TEMPORARY TABLESPACES FOR PDBS

LAB 9: ADVANCED MULTITENANT

LAB 9 SOLUTIONS: ADVANCED MULTITENANT ?

CHAPTER 10 ULTIMATE MULTITENANT

THE STARTUP COMMAND WITHIN PDBS

STARTUP PLUGGABLE DATABASE

SHUTDOWN WITHIN PDBS

ALTER SYSTEM SET STATEMENTS IN CDBS

THE CONTAINER CLAUSE IN DDL STATEMENTS

RUNNING SCRIPTS IN ALL CONTAINERS

AUTOMATING TNSNAMES.ORA MAINTENANCE

LAB 10: ULTIMATE MULTITENANT

LAB 10 SOLUTIONS: ULTIMATE MULTITENANT ?

CHAPTER 11 MULTITENANT ROUNDUP

RENAMING A PLUGGABLE DATABASE

MOVING A PDB

USING ORACLE MANAGED FILES WITH CDBS

THIS IS FOR YOUR OWN GOOD!

A BRIEF WORD ON DATA GUARD

MULTITENANT ENHANCEMENTS IN RELEASE 2

Parallel PDB Creation

Hot Cloning PDBs

Converting Release 1 PDBs To Use LOCAL UNDO

DEFAULT TABLESPACE CLAUSE IN CLONING

RELAXED CHARACTER SET RESTRICTIONS

SUPPORT FOR INDIVIDUALIZED PDB TIME ZONES

FLASHBACK DATABASE

RELOCATING PDBS ONLINE

LAB 11: MULTITENANT ROUNDUP

LAB 11 SOLUTIONS: MULTITENANT ROUNDUP

CHAPTER 12 ? STORAGE AND SECURITY

NEW SUPER USERS

ENHANCED SECURITY FOR CDBS

TEMPORARY TABLESPACE CONSIDERATIONS FOR CDBS

HARDENING A CDB

STORAGE CLAUSES RELEVANT TO PDBS

ALTER SYSTEM IN A PDB

SCOPE = SPFILE In PDBs

SERVICES AND PDBS

VIEWS IN CDBS

CON_ID Details

OTHER INTERESTING CDB VIEWS

CDB VIEW EXAMPLES

NEW FUNCTIONS FOR CONTAINERS

TRIGGERS IN A CDB

MOVING DATAFILES ONLINE

RAW PARTITIONS

DATABASE SMART FLASH CACHE SUPPORT

NETWORK FILE SYSTEM CAPABILITY

LAB 12: STORAGE AND SECURITY

LAB 12 SOLUTIONS: STORAGE AND SECURITY ?

CHAPTER 13 BACKUP AND RECOVERY FOR CDBS

CONTAINER DATABASE CONSIDERATIONS

BACKUP SETUP

BACKING UP THE ENTIRE CDB

BACKING UP JUST THE ROOT CONTAINER

BACKING UP PDBS

BACKING UP TABLESPACES AND DATAFILES FROM WITHIN A PDB

EXECUTING RMAN ACROSS PDBS

REDO LOG, ARCHIVE LOG AND CONTROLFILE BACKUPS IN CDBS

COMPLETE RECOVERY OF A CDB

COMPLETE RECOVERY OF A PDB

COMPLETE RECOVERY OF THE ROOT CONTAINER

INCOMPLETE RECOVERY OF THE ENTIRE CDB

INCOMPLETE RECOVERY OF PDBS

LOSS OF SYSTEM TABLESPACE IN A PDB

RMAN RESTRICTIONS IN PDBS

PRIOR BACKUPS AND ARCHIVELOGS FOR CONVERTED NON-CDBS

FLASHBACK AND CDBS

DATA PUMP AND CDBS

LAB 13: BACKUP AND RECOVERY FOR CDBS

LAB 13 SOLUTIONS: BACKUP AND RECOVERY FOR CDBS ?

CHAPTER 14 AUTOMATIC DATA OPTIMIZATION

STORAGE AND COMPRESSION TIERING

THE HEAT MAP

AUTOMATIC DATA OPTIMIZATION

COMPRESSION LEVELS

DATA DICTIONARY VIEWS FOR ADO

LAB 14: AUTOMATIC DATA OPTIMIZATION

LAB 14 SOLUTIONS: AUTOMATIC DATA OPTIMIZATION ?

CHAPTER 15 IN-DATABASE ARCHIVING

TO KEEP OR NOT TO KEEP

THE ROW ARCHIVAL CLAUSE

ORA_ARCHIVE_STATE

ROW ARCHIVAL VISIBILITY

LAB 15: IN-DATABASE ARCHIVING

LAB 15 SOLUTIONS: IN-DATABASE ARCHIVING ?

CHAPTER 16 AUDITING ENHANCEMENTS

UNIFIED AUDITING

ENABLING UNIFIED AUDITING

DISABLING UNIFIED AUDITING

HANDLING EARLIER AUDIT RECORDS

CREATING A SEC_ADMIN ACCOUNT

CREATING A UNIFIED AUDIT POLICY

AUTOMATIC AUDITS WITH UNIFIED AUDITING

DISABLING / DROPPING AUDIT POLICIES

IMMEDIATE-WRITE VS. QUEUED-WRITE MODE

AUDIT DATA CLEANUP

NEW UNIFIED AUDITING FEATURES IN RELEASE 2

LAB 16: AUDITING ENHANCEMENTS

LAB 16 SOLUTIONS: AUDITING ENHANCEMENTS ?

CHAPTER 17 PRIVILEGE ENHANCEMENTS

CONSIDERATIONS REGARDING PASSWORD CASE SENSITIVITY

PROFILES AND PASSWORD POLICIES

ROLES IN ORACLE12C

SEPARATION OF DUTY

INHERIT [ ANY ] PRIVILEGES

PERMISSION CONTROL WITHIN VIEWS

DATABASE PRIVILEGE ANALYSIS

RESTRICTIONS ON PRIVILEGE ANALYSIS

POTENTIAL BENEFITS OF PRIVILEGE ANALYSIS

PRIVILEGE ANALYSIS IN CONTAINER DATABASES

PRIVILEGE ANALYSIS POLICIES

DISABLING A PRIVILEGE ANALYSIS POLICY

GENERATING A PRIVILEGE ANALYSIS REPORT

DROPPING A PRIVILEGE ANALYSIS POLICY

SIGNIFICANT CHANGES TO ROLES AND PRIVILEGES

LAB 17: PRIVILEGE ENHANCEMENTS

LAB 17 SOLUTIONS: PRIVILEGE ENHANCEMENTS ?

CHAPTER 18 DATA REDACTION

OVERVIEW OF DATA REDACTION

EXEMPTION FROM REDACTION POLICIES

HOW AND WHEN REDACTION OCCURS

REDACTION EXAMPLES

FUNCTION_PARAMETERS FOR PARTIAL REDACTION

USING REGULAR EXPRESSIONS

USING RANDOM VALUES IN REDACTION

THE EXPRESSION PARAMETER

ENABLE / DISABLE / DROP REDACTION POLICIES

USING RES FOR PARTIAL VARCHAR2 REDACTIONS

NEW REDACTION PROCEDURES IN RELEASE 2

REDACTION_POLICIES / REDACTION_COLUMNS

LAB 18: DATA REDACTION

LAB 18 SOLUTIONS: DATA REDACTION ?

CHAPTER 19 RMAN ENHANCEMENTS

NEW BACKUP SUPER USER

RMAN CONNECTIONS

SELECT AND DESCRIBE FROM WITHIN RMAN

SIMPLER SQL COMMANDS

DUPLICATE WITH NOOPEN

CROSS-PLATFORM BACKUP AND RESTORE

RECOVERY OVER A NETWORK

STORAGE SNAPSHOT TECHNOLOGY

TABLE AND PARTITION RECOVERY

MULTISECTION BACKUPS ON VERY LARGE FILES

ACTIVE DATABASE DUPLICATION ENHANCEMENTS

TABLESPACE TRANSPORTS ACROSS PLATFORMS AND ENDIANNESS

CONVERT AT SOURCE

RESTORE FROM CONVERTED AT SOURCE

CONVERT AT TARGET

RESTORE FROM CONVERTED AT TARGET

STANDBY DATABASE UPDATING

DATA GUARD ENHANCEMENTS

ORACLE SCHEDULER SCRIPT JOBS

MEMORY-RESIDENT (A.K.A. IN-MEMORY) SCHEDULER JOBS

ENHANCEMENTS ADDED IN ORACLE 12C RELEASE 2 ?

CHAPTER 20 DB OPERATIONS

DATABASE OPERATIONS

DO MONITORING USE CASES

ENABLING DATABASE OPERATIONS MONITORING

DB OPERATIONS MONITORING ARCHITECTURE OVERVIEW

DO ATTRIBUTES

USING DBMS_SQL_MONITOR

BEGIN_OPERATION Function

END_OPERATION Procedure

REPORT_SQL_MONITOR Function

SIMPLE DATABASE OPERATIONS MONITORING EXAMPLE

THE ACTIVE REPORT TYPE

NEW OPTIMIZER HINTS

LAB 20: DB OPERATIONS

LAB 20 SOLUTIONS: DB OPERATIONS ?

CHAPTER 21 SCHEMA AND DATA CHANGES

DATABASE CHANGES

CHANGE MANAGEMENT CAPABILITIES

THE DBMS_COMPARISON PACKAGE

THE CREATE COMPARISON PROCEDURE

THE COMPARE FUNCTION

DISCOVERING DIFFERENCES

THE CONVERGE PROCEDURE

THE RECHECK FUNCTION

THE DBA_COMPARISON_COLUMNS VIEW

LAB 21: SCHEMA AND DATA CHANGES

LAB 21 SOLUTIONS: SCHEMA AND DATA CHANGES ?

CHAPTER 22 SQL TUNING

ADAPTIVE EXECUTION PLANS

DBMS_XPLAN AND ADAPTIVE EXECUTION PLANS

SQL PLAN DIRECTIVES / EXTENDED STATISTICS

ENHANCED STATISTICS GATHERING

HISTOGRAM ENHANCEMENTS

LAB 22: SQL TUNING

LAB 22 SOLUTIONS: SQL TUNING ?

CHAPTER 23 REAL-TIME ADDM / PERFORMANCE

THE AUTOMATIC DATABASE DIAGNOSTIC MONITOR

REAL-TIME ADDM

EMERGENCY MONITORING / CURRENT ADDM FINDINGS

MONITORING THE DATABASE WITH THE NEW EMDE

USING THE PERFORMANCE HUB

The Summary Tab

The RAC Tab

The Activity Tab

The Workload Tab

The Monitored SQL Tab

The ADDM Tab

The Database Time Tab

The Resources Tab

The System Statistics Tab

The Containers Tab

WORKLOAD REPOSITORY REPORTS

MODIFYING AUTOMATIC SNAPSHOT SETTINGS

USING OTHER ADVISORS

SQL Tuning Advisor Details

The Automatic SQL Tuning Advisor

SQL Access Advisor

DATABASE REPLAY

Workload Intelligence Overview

Workload Dimensions

Reports

SECUREFILES

PGA_AGGREGATE_LIMIT

REAL APPLICATION TESTING

PATCH INVENTORY PACKAGE

STATISTICS ENHANCEMENTS

AUTOMATIC COLUMN GROUP DETECTION

CONCURRENT STATISTICS GATHERING

INCREMENTAL STATISTICS ENHANCEMENTS

GLOBAL TEMPORARY TABLES SESSION-PRIVATE STATISTICS

REPORTING MODE

PAST STATISTICS COLLECTION REPORTS

LAB 23: REAL-TIME ADDM / PERFORMANCE

LAB 23 SOLUTIONS: REAL-TIME ADDM / PERFORMANCE ?

CHAPTER 24 RESOURCE MANAGER FOR CDBS

RESOURCE MANAGER AND CDBS

CDB RESOURCE PLANS

THE INITIAL DEFAULT DIRECTIVE ATTRIBUTES FOR PDBS

PDB RESOURCE PLANS

BACKGROUND AND ADMINISTRATIVE TASKS

CREATING THE RESOURCE PLAN FOR THE CDB

UPDATING THE CDB RESOURCE PLAN

ADDING A NEW PLAN DIRECTIVE FOR A PDB

DELETING A PDB?S PLAN DIRECTIVE

ENABLING THE CDB RESOURCE PLAN

DISABLING THE CDB RESOURCE PLAN

DELETING THE ENTIRE CDB RESOURCE PLAN

CREATING / MODIFYING PDB RESOURCE PLANS

ENABLING / DISABLING PDB RESOURCE PLANS

RESOURCE MANAGER VIEWS

ENABLING RESOURCE MANAGER IN PDBS

USING CLOUD CONTROL WITH RESOURCE MANAGER

RUNAWAY QUERY MANAGEMENT

DBMS_SCHEDULER WITH A CDB

RELEASE 2 ENHANCEMENTS

LAB 24: RESOURCE MANAGER FOR CDBS

LAB 24 SOLUTIONS: RESOURCE MANAGER / PERFORMANCE ?

CHAPTER 25 TABLE / INDEX ENHANCEMENTS

CREATING MULTIPLE INDEXES ON COLUMNS

ADVANCED ROW COMPRESSION

ONLINE REDEFINITION ENHANCEMENTS

SPLIT PARTITION AND SUBPARTITION (R1)

OTHER RELEVANT RELEASE 1 NEW FEATURES

DML_LOCK_TIMEOUT

EDITIONING ENHANCEMENTS

CONVERSION OF A NONPARTITIONED TABLE

CREATE TABLE FOR EXCHANGE (CTFE)

MONITORING INDEX USAGE

DBA_INDEX_USAGE

V$INDEX_USAGE_INFO

OPTIMIZER STATISTICS ADVISOR

SUBPARTITIONED INTERVAL PARTITIONS

LIST PARTITIONING ENHANCEMENTS

LAB 25: TABLE / INDEX ENHANCEMENTS

LAB 25 SOLUTIONS: TABLE / INDEX ENHANCEMENTS ?

CHAPTER 26 ADR / NETWORK ENHANCEMENTS

ADR DIRECTORY STRUCTURE

ADR COMMAND INTERPRETER ENHANCEMENTS

ADVANCED NETWORK COMPRESSION

MULTIPROCESS / MULTITHREADED ARCHITECTURE

VERY LARGE NETWORK BUFFERS ?

CHAPTER 27 DATA LOADING ENHANCEMENTS

DATA PUMP ENHANCEMENTS

DATA PUMP VIEWS_AS_TABLES

TRANSFORM CLAUSE ENHANCEMENTS

NEW PARAMETERS

LOG MINER ENHANCEMENTS

FULL TRANSPORTABLE EXPORT / IMPORT

SQL*LOADER ENHANCEMENTS

SQL*Loader Express Mode

SQL*LOADER ENHANCEMENTS

SQL*LOADER / EXTERNAL TABLE COMMON ENHANCEMENTS

EXTERNAL TABLE PARAMETER OVERRIDE

EXTERNAL TABLE ENHANCEMENTS

REAL-TIME MATERIALIZED VIEWS

LAB 27: DATA LOADING ENHANCEMENTS

LAB 27 SOLUTIONS: DATA LOADING ENHANCEMENTS ?

CHAPTER 28 PARTITIONING ENHANCEMENTS

MOVING PARTITIONS ONLINE

INTERVAL-REFERENCE PARTITIONING

ENHANCED CASCADE FUNCTIONALITY

OPERATING ON MULTIPLE PARTITIONS

PARTIAL INDEXES

GLOBAL INDEX MAINTENANCE

CONTROLLING STATISTICS GATHERING FOR PARTITIONS ?

CHAPTER 29 NEW FEATURES IN 12.1.0.2

ABOUT 12.1.0.2

ADVANCED INDEX COMPRESSION

APPROX_COUNT_DISTINCT

ENHANCED APPROXIMATIONS IN RELEASE 2

The New Approximation Functions

The New Approximation Parameters

ATTRIBUTE CLUSTERING

BIG TABLE CACHING

FLASHBACK DATA ARCHIVE SUPPORT FOR CDBS

FULL DATABASE CACHING

IN-MEMORY AGGREGATION

IN-MEMORY COLUMN STORE

Working With Tables

Working With Columns

Working With Tablespaces

Working With Materialized Views

DATA PUMP AND INMEMORY

ENHANCEMENTS IN RELEASE 2

SUPPORT FOR JSON

FIPS 140 ENCRYPTION PARAMETER

PDB CONTAINERS CLAUSE IN QUERIES

OMF FILE REPLACEMENT FOR PDBS

THE PDB LOGGING CLAUSE

PDB METADATA CLONES

PDB REMOTE CLONES

PLATFORM SUPPORT FOR PDB SNAPSHOT CLONING

THE PDB STANDBYS CLAUSE

STATE MANAGEMENT FOR PDBS ACROSS PDB RESTART

PDB SUBSET CLONING

RAPID HOME PROVISIONING

ZONE MAPS

CHAPTER 30 SQLCL

THE DEATH OF SQL*PLUS?

INSTALLATION

CONNECTING

EDITING / AUTOCOMPLETE

Autocomplete (TAB Completion)

SQLFORMAT ANSICONSOLE

NEW COMMANDS

ALIAS

APEX

BRIDGE

CD

CTAS

DDL

FIND

FORMAT

HISTORY

INFORMATION

LOAD

NET

OERR

REPEAT

REST

SODA

SSHTUNNEL

TNSPING

WHICH

MISCELLANEOUS

LAB 30: SQLCL

LAB 30 SOLUTIONS: SQLCL ?

CHAPTER 31 APPLICATION EXPRESS 5.0

PACKAGED APPLICATIONS

PAGE DESIGNER

The Toolbar

The Tree Pane

The Central Pane

Property Editor

Gallery Pane

UNIVERSAL THEME

USER INTERFACE ENHANCEMENTS

IMPROVED APPLICATION BUILDER DESIGN

INTERACTIVE REPORTING

MOBILE ENHANCEMENTS

ALL NEW CALENDAR

APEX EXAMPLES

The Desktop Application

The Mobile Application ?

CHAPTER 32 RESOURCE MANAGEMENT IN R2

MEMORY MANAGEMENT FOR PDBS

I/O MANAGEMENT FOR PDBS

CPU MANAGEMENT FOR PDBS

SYSTEM ACCESS

LOCKDOWN PROFILES

CREATE LOCKDOWN PROFILE

ALTER LOCKDOWN PROFILE

DROP LOCKDOWN PROFILE

SETTING PDB_LOCKDOWN

EXAMPLES

LAB 32: RESOURCE MANAGEMENT IN R2

LAB 32 SOLUTIONS: RESOURCE MANAGEMENT IN R2 ?

CHAPTER 33 ORACLE SHARDING

ORACLE SHARDING

SHARDING BENEFITS

SHARDING COMPONENTS

APPLICATION SUITABILITY ?

CHAPTER 34 APPLICATION CONTAINERS

WHAT ARE APPLICATION CONTAINERS?

APPLICATION CONTAINER CREATION

APPLICATION CREATION

APPLICATION PDB CREATION

APPLICATION CONTAINER MANAGEMENT

APPLICATION SEED CREATION

CONTAINERS QUERY HINTS

LAB 34: APPLICATION CONTAINERS

LAB 34 SOLUTIONS: APPLICATION CONTAINERS ?

CHAPTER 35 18C NEW FEATURES

APPLICATION DEVELOPMENT

Application Express

General Application Development Enhancements

Graph / Spatial Capabilities

JSON

Simple Oracle Document Access (SODA) For PL/SQL

Simple Oracle Document Access (SODA) For C And C++

JSON Key Name Indexing

PL/SQL Hierarchical Profiler Enhancements

PL/SQL Qualified Expressions

Sharded Database Spatial Database Support

Oracle XA Transactions Spatial Support

Enhanced JSON Support For Spatial

Text Enhancements

HIGH AVAILABILITY

Data Guard

General Availability

BIG DATA / DATA WAREHOUSING

Analytic View Enhancements

Data Mining Enhancements

GENERAL DATABASE ENHANCEMENTS

Manual Run-Away Query Termination

Inline External Tables

Polymorphic Table Functions

LOBs And In-Memory / Big Data SQL

Copying PDBs In A Data Guard Environment

DBCA PDB Clone

PDB Lockdown Profile Enhancements

Refreshable PDB Switchover

PDB Snapshot Carousel

Globalization

Database Password File

The Read-Only Oracle Home

Partitioning Enhancements

SQL Tuning Sets

SQL Performance Analyzer

PERFORMANCE ENHANCEMENTS

In-Memory Enhancements

Scalable Sequences

GRID / RAC

ASM PDB Cloning

SECURITY ENHANCEMENTS

User-Defined Master Encryption Key Creation

Data Pump And Encrypted Passwords For Database Links

PDB Keystores

Data Pump And The Unified Audit Trail

Active Directory Services Integration

Schema Only Accounts

Credential Data Encryption

Database Replay File Encryption

Database Vault Support For Database Replay ?

CHAPTER 35 DEPRECATIONS & DESUPPORTS

DEPRECATED FEATURES FOR RELEASE 1

DESUPPORTED FEATURES FOR RELEASE 1

DEPRECATED PARAMETERS FOR RELEASE 1

Networking

Database

DEPRECATED VIEWS FOR RELEASE 1

DEPRECATED FEATURES FOR RELEASE 2

DESUPPORTED FEATURES FOR RELEASE 2

DEPRECATED PARAMETERS FOR RELEASE 2

DESUPPORTED PARAMETERS FOR RELEASE 2

DEPRECATED VIEWS FOR RELEASE 2

PARAMETER DEFAULT CHANGES FOR RELEASE 2

DEPRECATIONS AND DESUPPORTS FOR 18C ?

What You Can Expect

Introduce the key new features of Oracle12c from Release 1 (12.1.0.1.0) through Oracle 18c (12.2.0.2)and how to take advantage of them.

Who Should Take This Course

This course is appropriate for anyone needing to learn key new features of Oracle12c from Release 1 (12.1.0.1.0) through Oracle 18c, which is essentially Oracle 12.2.0.2. That would include end users, business analysts, application developers, database administrators and IT management.

Recommended Prerequisites

A thorough knowledge of Oracle11g database administration is required. Full familiarity with Oracle11g PL/SQL is highly desirable.

Training Style

Lecture and Hands on Labs

Related Courses
Code Course Title Duration Level
OR11A1
Oracle Database 11g Administration I
5 Days
I
Details
OR11E
Oracle 11g/12c Essentials: SQL, SQL*Plus and PL/SQL
5 Days
I
Details
OR11D
Oracle 11g/12c Developer: PL/SQL Complete
5 Days
I
Details
OR11A2
Oracle Database 11g Administration II & Backup and Recovery Workshop
4 Days
II
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.