Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

Upgrading to Oracle12c Training

© 2016 by Burleson Corporation

 

This 12c upgrade training course course is taught at your Company site with up to 20 students. 

Click here for on-site upgrade to 12c training course prices

Don't forget supplemental 12c mentoring

 

Key Features

* Learn the most important 12c new features and when to use them.

* Understand how to leverage the automatic DBA features.

* See how the Automated Workload Repository (AWR) places important tuning information at your fingertips.

* Use the Automated Session History (ASH) tables to quickly find performance bottlenecks.

* Understand how to use the Automatic Database Diagnostic Monitor (ADDM).

* Learn how to implement the SQLTuning and SQLAccess advisor tools.
 

 

 

  

Course Description

Unlike some mediocre Oracle 12c upgrade training, this course examines all Oracle12c new features with an eye on those features that are the most important to Upgrading to Oracle12c.

This Oracle 12c upgrade training is special because this course is taught by a veteran Oracle Certified DBA with years of full-time experience.
 

Book Required

 

Audience

This upgrading to 12c training course is designed for practicing Oracle professionals who have basic experience with Oracle. Prior experience with Oracle is not required, but experience using Oracle database is highly desirable.
 

 

Curriculum Design

This upgrading to Oracle 12c training class was designed by Donald K. Burleson, an acknowledged leader in Oracle database administration.  Author of more than 30 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning. Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle new features training.

Course Duration

This is an intensive 2-day Oracle 12c Upgrade overview.  This course is a comprehensive overview of Oracle12c, taught by a leading Oracle12c trainers. 



Upgrading to 12c Training  Course
2-Day Syllabus

12c upgrade training - Copyright © 2016 by Donald K. Burleson

 

 

Introduction to 12c New Features for developers

Inside 12c New Features  
OEM - Enterprise Manager Oracle 12c new features
Oracle 12c New Features Programming Language Support 
Oracle 12c PL/SQL New Features          
Oracle SQL optimizer (CBO) Improvements       
Oracle 12c SQL New Features    
   

OEM Oracle 12c new features

Introduction to OEM  12c       

Oracle 12c PL/SQL New Features

12c Performance Tuning Features

New Performance Tuning Features        
Inside Extended Optimizer Statistics       
  

RAC enhancements

RAC Transaction guard - evolution of TAF

Core Database Enhancements in Oracle12c

Interval-REF partitioning
identity columns (automatic PK generation)
VARCHAR2(32767) for LOB's (up from VARCHAR(4000)
ILM clause - Integrated lifecycle Management
12c Transaction Guard 
Pluggable Database 
Real-time ADDM
ASH Analytics

 

SQL Management

SQL Commonality Index 
Adaptive execution plans 
Hybrid Histograms 
WITH clause enhancement to allow functions
Booleans in SQL
I
mproved optimizer statistics

Oracle 12c security enhancements

- A PL/SQL unit can have roles granted to it.
- Allowing SQL creation and management of wallets, rather than command line utilities. Allows easier remote management.
- Code-Based Access Control (CBAC):
- Data Redaction: A variation in column masking of VPD, but it doesn’t just blank the value and still allows queries against the column in the WHERE clause.
- Doesn’t affect compile time, so focusing very much on dynamic SQL.
- Encryption Enhancements:
- Enhanced Security of Audit Trail:
- Export and import wallets/keys between plugable databases.
- Extension of the audit management package.
- inherited rights : Control accidental privilege escalation when a privileged user calls an invoker rights unit containing malicious code.
- Invoker Rights management
- Invokers rights for views.
- Monitoring controlled using dbms_privilege_capture.
- Multiple audit management privileges.
- New Separation of Duties:
- Privilege Analysis:
- Report what is used and what is not used.
- Roles for audit management.
- Single unified audit trail.
- Storage of wallets in ASM.
- SYSBACKUP – Just enough to do a backup.
- SYSDG – Just enough for data guard administration.
- SYSKM – Just enough to perform basic key management tasks.
- SYSOPER – More limited than SYSDBA, but still very powerful.
- Tracking direct privileges and privileges via roles
- Useful on invoker rights, since now the PL/SQL can run with user privileges and explicitly granted roles for the unit.
- When the unit runs, any dynamic SQL running can have the privileges granted via the role.

 

   

This is a BC Oracle training course (c) 2016

 

   

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.