Audience
This course is appropriate for anyone needing to learn key new features of Oracle12c. That would include end users, business analysts, application developers, database administrators and IT management.
Prerequisites
A thorough knowledge of Oracle11g database administration is required. Full familiarity with Oracle11g PL/SQL is highly desirable.
Duration
5 Days
Outline for Oracle Database 12c: New Features for Administrators Training
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
- MISCELLANEOUS NEW SQL FEATURES
- 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
- 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
- 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
- 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
- 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
- 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
- Server 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
- 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
- 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
- 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
- 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
- BUILDING A UNIFIED PARAMETER QUERY
- 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
- 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
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
- LAB 16: AUDITING ENHANCEMENTS
- LAB 17 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
- REDACTION_POLICIES / REDACTION_COLUMNS
- LAB 18: DATA REDACTION
- LAB 18 SOLUTIONS: DATA REDACTION
CHAPTER 19 – 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
- LAB 19: RMAN / FDA ENHANCEMENTS
- LAB 19 SOLUTIONS: RMAN / FDA ENHANCEMENTS
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 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
- 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
- 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
- DML_LOCK_TIMEOUT
- EDITIONING 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
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