Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle 12c -18c New Features For Administrators
Oracle Training Overview

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.

Oracle Training Audience

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.

Oracle Training Prerequisites

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

Course duration

5 Days

Oracle Training Course outline

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

 


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy