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
• MISCELLANEOUS NEW SQL FEATURES
• DATA MODEL REVIEW

PL/SQL ENHANCEMENTS

• WHITE LISTS
• THE WITH CLAUSE FOR FUNCTIONS
• PRAGMA UDF
• NEW INQUIRY DIRECTIVES
• NEW DBMS_SQL FUNCTIONALITY
• ENHANCED LANGUAGE INTERFACE FEATURES
• MISCELLANEOUS NEW PL/SQL FEATURES FOR ORACLE12C

INSTALLATION / UPGRADING

• OVERVIEW OF DATABASE CREATION
• THE ORACLE UNIVERSAL INSTALLER
• PREREQUISE TASKS
  • Memory Requirements
  • Hardware Requirements
  • Software Requirements
  • Package Requirements
  • What About Windows?
• RUNNING THE INSTALLER
• POST INSTALLATION
• USING THE DATABASE CONFIGURATION ASSISTANT
• USING THE DATABASE CONFIGURATION ASSISTANT ? SHORT FORM
• DATABASE TEMPLATES
• UPGRADING THE DATABASE
• REMOVING ORACLE SOFTWARE

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

SQL DEVELOPER / SQL*PLUS

• SQL DEVELOPER
• MULTITENANT CONNECTION CONSIDERATIONS
• USING SQL DEVELOPER
• SQL*PLUS FOR ORACLE12C
  • Invisible Columns
  • New SHOW Commands
  • Last Login Time
  • Support For The New Administrative Privileges
  • Support For Pluggable Databases

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
  • Server Control (SRVCTL)

MULTITENANT BASICS

• CREATING CDBS
• FEATURES UNSUPPORTED FOR MULTITENANT ARCHITECTURE
• THE CREATE DATABASE COMMAND
• Seed Data Files
• CONFIGURING ENTERPRISE MANAGER DATABASE EXPRESS FOR CDBS
• USING SQL DEVELOPER WITH CDBS AS A DBA

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
• UNPLUGGING A PDB
• CREATING A PDB BY PLUGGING IN AN UNPLUGGED PDB
• CREATING A PDB FROM A NON-CDB DATABASE
  • Using DBMS_PDB
• NEW TRIGGER TYPES FOR PDBS
  • The BEFORE UNPLUG Trigger
  • The AFTER CLONE Trigger

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

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

MULTITENANT ROUNDUP

• RENAMING A PLUGGABLE DATABASE
• MOVING A PDB
• BUILDING A UNIFIED PARAMETER QUERY

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

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

AUTOMATIC DATA OPTIMIZATION

• STORAGE AND COMPRESSION TIERING
• THE HEAT MAP
• AUTOMATIC DATA OPTIMIZATION
• COMPRESSION LEVELS

IN-DATABASE ARCHIVING

• TO KEEP OR NOT TO KEEP
• THE ROW ARCHIVAL CLAUSE
• ORA_ARCHIVE_STATE
• ROW ARCHIVAL VISIBILITY

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

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

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
• REDACTION_POLICIES / REDACTION_COLUMNS

RMAN / FDA 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

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

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

SQL TUNING

• ADAPTIVE EXECUTION PLANS
• DBMS_XPLAN AND ADAPTIVE EXECUTION PLANS
• SQL PLAN DIRECTIVES / EXTENDED STATISTICS
• ENHANCED STATISTICS GATHERING
• HISTOGRAM ENHANCEMENTS

REAL-TIME ADDM / PERFORMANCE

• THE AUTOMATIC DATABASE DIAGNOSTIC MONITOR
• REAL-TIME ADDM
• EMERGENCY MONITORING / CURRENT ADDM FINDINGS
• MONITORING THE DATABASE WITH 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 Current ADDM Findings Tab
  • The Database Time Tab
  • The Resources Tab
  • The System Statistics 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

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

TABLE / INDEX ENHANCEMENTS

• CREATING MULTIPLE INDEXES ON COLUMNS
• ADVANCED ROW COMPRESSION
• ONLINE REDEFINITION ENHANCEMENTS
• DML_LOCK_TIMEOUT
• EDITIONING ENHANCEMENTS

ADR / NETWORK ENHANCEMENTS

• ADR DIRECTORY STRUCTURE
• ADR COMMAND INTERPRETER ENHANCEMENTS
• ADVANCED NETWORK COMPRESSION
• MULTIPROCESS / MULTITHREADED ARCHITECTURE
• VERY LARGE NETWORK BUFFERS

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

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