Home About Courses Schedule Services Webinars Contact Search

Oracle 18c New Features for Administrators

SEE SCHEDULE

Duration: 3.0 days

Method: Instructor led, Hands-on workshops

Price: $1920.00

Course Code: OR5860


Audience

Oracle Database Administrators.

Description

Many features get overlooked every time a new version of the database is released. Learn and try the new features that will provide you the needed means in your environment that have been missing in prior releases. In this course Database Administrators, through hands-on exercises, get the opportunity to examine and test many of the new features in Oracle 18c giving them a feel for how each feature works and whether or not the feature has a place in their work environments.

Prerequisites

Some Oracle DBA experience or knowledge.

Topics

  • I. Database New Features and Changes
    • Online Merging of Partitions and Subpartitions
    • Modifying the Partitioning Strategy
    • Scalable Sequences
    • Dropping Oracle ASM File Groups with a Cascade Option
    • Ability to Use Encrypted Passwords for Database Links with Oracle Data Pump
    • Ability to Use Oracle Data Pump to Export and Import the Unified Audit Trail
    • Ability to Create Schema Only Accounts
    • Manual termination of Run-Away Queries
    • Miscellaneous Database Changes
    • Deprecated Features
    • Desupported Features
  • II. SQL New Features and Enhancements
    • Private Temporary Tables
    • Ability to Create Schema Only Accounts
    • Approximate Top-N Query Processing
    • Non-Persistable Data Types
    • SQL*Plus Changes
    • SQL Developer Changes
    • Miscellaneous SQL Changes
    • Deprecated Features
    • Desupported Features
  • III. PL/SQL New Features and Enhancements
    • Non-Persistance Support for Object Types
    • Polymorphic Table Functions
    • PL/SQL Hierarchical Profiler (DBMS_HPROF) Enhancements
    • PL/SQL Qualified Expressions
    • Miscellaneous PL/SQL Changes
    • Deprecated Features
    • Desupported Features
  • IV. Performance New Features and Changes
    • SQL Tuning Advisor Exadata Enhancements
    • New SQL Tuning Set API
    • Concurrent SQL Execution with SQL Performance Analyzer
    • SQL Performance Analyzer Result Set Validation
    • Memoptimized Rowstore
    • Manual termination of Run-Away Queries
    • SQL Tuning Advisor Exadata Enhancements
    • New SQL Tuning Set API
    • Concurrent SQL Execution with SQL Performance Analyzer
    • SQL Performance Analyzer Result Set Validation
    • Memoptimized Rowstore
    • Private Temporary Tables
    • Manual termination of Run-Away Queries
    • Miscellaneous Performance Changes
    • Deprecated Features
    • Desupported Features
  • V. Utilities New Features and Changes
    • Data Pump Skip Continues Loading When Data Format Error is Encountered
    • SQL*Plus Changes
    • SQL Developer Changes
    • Miscellaneous Utilities Changes
    • Deprecated Features
    • Desupported Features