Nada mudou no Oracle desde o 10g

A alguns dias atrás, eu ouvi um DBA SQL Server dizer a seguinte frase: “Do Oracle 10g de 2006 ao 12c (última versão até então) pouca coisa mudou…”. E acho que não é um caso isolado, creio que esta impressão é generalizada em quem não conhece muito o produto.

Como eu não gosto de mitos, decidi então ir atrás, e compilar todas as New Features do 11gR1 ao 12cR2, última versão de produção disponível, e encontrei exatas 1250 New Features.

11gR1
– Client-Side Query Cache
– OCI Client Session NLS Character Set Status Information
– Precompilers: Additional Array INSERT and SELECT Syntax Support by Pro*C/C++ and Pro*COBOL
– Precompilers: Dynamic SQL Statement Caching in Pro*C/C++ and Pro*COBOL
– Precompilers: Fix Execution Plan in Pro*C/C++ and Pro*COBOL
– Precompilers: Flexible B Area Length for Pro*COBOL
– Precompilers: Implicit Buffered Insert in Pro*C/C++ and Pro*COBOL
– Precompilers: Platform Endianness Support by Pro*COBOL
– Precompilers: Scrollable Cursor Support in Pro*COBOL
– Precompilers: SQL99 Syntax Support by Pro*C/C++
– Application and Schema Comparison
– Drag and Drop Item Layout
– Flash Charts
– Friendly URL Syntax to Facilitate Bookmarks
– Improved Web Services
– Improved Workspace Management
– Microsoft Access Migration
– New Password and Account Controls
– Page and Region Caching
– PDF Printing
– Create Rules and Actions for DML Events With Rules Manager
– Enhanced Rules Manager
– New Capabilities for Domain Index Operations
– Oracle Text Predicates and Aggregate Operators are Included in Rule Conditions
– Oracle Text Predicates Included in Stored Expressions
– System-Managed Partitioning of Extensible Indexes
– Unicode 5.0 Support
– OracleJVM Java/JDK 5.0 Compatibility
– OracleJVM JIT Configuration
– OracleJVM JIT (Transparent Native Java Compilation Without a C Compiler)
– OracleJVM Ease-of-Use: JDK-Like Interface
– OracleJVM Ease-of-Use: Property Management Interface
– OracleJVM Ease-of-Use: Output Redirect
– OracleJVM Ease of Use: Database Resident Jars
– OracleJVM Ease of Use: Two-Tier Java Session Termination
– OracleJVM Utilities Enhancements
– OracleJVM Manageability: JMX Interface
– JDBC 4.0 Connection and Statement Enhancements
– JDBC 4.0 Support for New Data Types
– JDBC Support for ANYTYPE and ANYDATA
– JDBC Support for Continuous Query Notification
– JDBC Support for Database Diagnosability
– JDBC Support for Database Startup and Shutdown
– JDBC Support for Native Streams AQ Protocol
– JDBC-Thin Support for Oracle Advanced Security
– SQLJ: Enhanced Profile Print Option of the Customizer
– SQLJ: Outline Generation Option
– SQLJ: Support for JDK 1.5
– SQLJ: XA Support
– General Visual Studio 2005 Support
– Oracle PL/SQL Debugger in Visual Studio
– Support for Visual Studio 2005 Data Sources Window and Designers
– Provider-Independent API Using Base Classes and Factories
– Connection String Builder
– OracleDataAdapter Batch Processing
– Row-Level Change Notifications
– Schema Discovery
– Data Source Enumeration
– Faster LOB Retrieval
– Improved Parameter Context Caching in Statement Caching
– Faster Performance
– Improved Metadata Caching
– Improved Statement Caching
– Database Resident Connection Pooling (DRCP)
– XA API Available Within PL/SQL
– Allow Sequences in PL/SQL Expressions
– Enhancements to the Regular Expression Built-Ins
– Functional Completeness of Dynamic SQL for PL/SQL
– Method Invocation Scoping Operator
– Named and Mixed Notation for User-Defined PL/SQL Subprogram in a SQL Statement
– New Compound Trigger Type
– PL/Scope
– PL/SQL CONTINUE Statement
– PL/SQL Hierarchical Profiler
– PL/SQL Inlining Optimization
– SIMPLE_INTEGER Data Type
– Binary XML Support for Java
– Binary XML Support for Oracle XML DB
– Configurable DOM Support for Java
– Event-Based XML Pull Parsing for C
– High Performance XPath Query for Java
– In-Place XML Schema Evolution
– Mid-Tier XQuery Engine Performance Improvements
– Pluggable DOM Support for Java
– Scalable and High Performance XML Validation for C
– Scalable DOM Support for Java
– Unified Java API for XML
– Unified Java API for XML
– XMLDiff Support for C
– XMLIndex Enhancements
– Browser-Based Enterprise Manager Integrated Interface for LogMiner
– Fast-Start Failover for Maximum Performance Mode in a Data Guard Configuration
– Compression of Redo Traffic (Only for Gap Resolution) Over the Network in a Data Guard Configuration
– Real-Time Query Capability of Physical Standby Database
– Fast Role Transitions in a Data Guard Configuration
– User Configurable Conditions to Initiate Fast-Start Failover in a Data Guard Configuration
– Dynamic Setting of Oracle Data Guard SQL Apply Parameters
– Enhanced Data Guard Broker Based Management Framework
– Enhanced Data Guard Management Interface (Using SQL*Plus)
– Histogram for Redo Transport Response Time in a Data Guard Configuration
– Snapshot Standby
– Strong Authentication for Data Guard Redo Transport
– Enhanced DDL Handling in Oracle Data Guard SQL Apply
– Enhanced Oracle RAC Switchover Support for Logical Standby Databases
– Oracle Scheduler Support in Data Guard SQL Apply
– Fine-Grained Auditing (FGA) Support in Data Guard SQL Apply
– Support Transparent Data Encryption (TDE) with Data Guard SQL Apply
– Support XMLType Data Type (Only CLOB) in Data Guard SQL Apply
– Virtual Private Database (VPD) Support in Data Guard SQL Apply
– Flashback Transaction
– SMP Scalable Redo Apply
– Transportable Databases Between Linux and Windows
– Flashback Data Archive
– Automatic Reporting of Corrupt Blocks
– Block Media Recovery Performance Improvements
– Creation and Recovery of Long-Term Backups Improved
– End-to-End Redo Validation
– Merge Catalogs
– Parallel Backup and Restore for Very Large Files
– Data Recovery Advisor
– Enhance LogMiner to Support Automatic Data Repair
– Integrated Protection From Various Data Corruptions
– Lost-Write Detection Using a Physical Standby Database
– DDL With the WAIT Option
– Enhanced ADD COLUMN Functionality
– Finer Grained Dependencies
– Invisible Indexes
– Minimize Dependent PL/SQL Recompilation After Online Table Redefinition
– Online Index Creation and Rebuild Enhancements
– Online Redefinition for Tables with Materialized View Logs
– Read-Only Tables
– Archive Log Management Improvements
– Fast Incremental Backups on Physical Standby Database
– Improved Backup Compression Performance
– Improved Integration with Data Guard
– Network-Aware DUPLICATE Command
– Optimized Undo Backup
– Read-Only Transported Tablespaces Backup
– Compressed Dump File Sets
– Data Pump API Enhancements
– Database Upgrade/Downgrade Enhancements
– Direct Path API Multiple Subtype Support
– Encrypted Dump File Sets
– Enhancements to Metadata API
– Oracle Data Pump External Table Enhancement
– Single Partition Transportable for Oracle Data Pump
– SQL*Plus BLOB Support
– Change Data Purge Enhancements
– Change Subscription Enhancements
– Enabling or Disabling Synchronous Change Data Capture
– Enhanced DML Tracking
– Enhanced Materialized View Catalog Views
– Query Rewrite Enhancement to Support Queries Containing Inline Views
– Query Rewrite Support of Queries on Remote Tables
– Refresh Performance Improvements
– Composite List-Hash Partitioning
– Composite List-List Partitioning
– Composite List-Range Partitioning
– Composite Range-Range Partitioning
– Interval Partitioning
– Metadata for SQL Built-In Operators and Functions
– OLTP Table Compression
– Reference Partitioning
– SQL PIVOT and UNPIVOT Operators
– System Partitioning
– Virtual Columns
– Virtual Column-Based Partitioning
– Cost-Based Aggregation of OLAP Cubes
– Cube Organized Materialized Views
– Fine-Grained Partitioning of OLAP Cubes
– OLAP Security Enhancements
– SQL Optimizer Support for OLAP Option Cubes and Dimensions
– Storage and Access Improvements of Compressed Cubes
– Unified OLAP API Metadata Change Management
– Automated and Embedded Data Transformations for Mining (Supermodels)
– Data Mining Schema Objects
– Java API for Oracle Data Mining (JSR-73)
– Multivariate Linear Regression
– Multivariate Logistic Regression
– Predictive Analytics: PROFILE
– SQL Prediction Enhancements
– Enhanced Oracle RAC Monitoring and Diagnostics in Enterprise Manager
– Enhanced Oracle Real Application Clusters Configuration Assistants
– OCI Runtime Connection Load Balancing
– Parallel Execution for Oracle Real Application Clusters
– Support for Distributed Transactions in an Oracle RAC Environment
– Fast Bulk Data Transfers
– LOB Prefetch
– SecureFiles
– SecureFiles: Compression
– SecureFiles: Deduplication
– SecureFiles: Encryption
– Improved Support for Advanced Features in More Languages
– Incremental Indexing Enhancements
– Oracle Enterprise Manager Support for Text
– Re-Create Index Online
– Composite Index
– More Types of Operations Allowed on Document Sections
– Text Support for Very Large Number of Partitions
– User-Defined Score
– Content Repository Management (JSR-170) Support for Java
– DAV ACL Support
– Enable the XDB HTTP Server for SOA
– Large Text Node Handling
– Oracle XML DB Repository Triggers
– Recursive Schema Handling
– Repository Performance Improvements
– Scalable XSL Output
– SQL/XML Standards Compliance and Performance Optimizations
– Support for More Types of Links in XDB
– XLink Support in XML DB
– XML DB Operational Completeness
– XML Query Optimization with Schemaless or Weakly-Typed Schema-Based XML
– XML Translation Support
– XML Update Performance Optimizations
– XMLIndex
– XQuery and SQL/XML Performance Improvements
– XQuery Standards Conformance
– XSLT Performance Improvements
– Automatic Inter-Component Deadlock Detection
– Hang Manager
– Incident Packaging Service (IPS)
– SQL Test Case Builder
– Automatic Diagnostic Repository
– Enhanced Network Diagnosability
– OCI Diagnosability
– Improved Block Corruption Detection
– SQL Repair Advisor
– Automatic Health Monitoring
– Automatic Quarantine of Corrupt Undo Segments
– Fast ANALYZE: Finding Table-Index Corruptions
– Holistic Undo Health Monitoring
– Support Workbench
– Event Notification Grouping and Management
– Oracle Scheduler for Streams Jobs
– Scalability for Streams Notifications
– Messaging Gateway Service-Based Failover
– Multiple Messaging Gateway Agents in Oracle RAC Environments
– Simplified Messaging Gateway Propagation Job Configuration
– Database Gateways: Performance Improvements
– Database Gateway for Adabas
– Database Gateway for IMS
– Database Gateway for VSAM
– Continuous Query Notification Enhancements
– Additional Data Type Support for Streams
– Spatial: 3-D Geometry, Surface, and Point Cloud Storage and Indexing Functions
– Spatial Web Services
– Spatial Routing Engine Enhancements
– Spatial Network Data Model Enhancements
– Load-On-Demand for Very Large Networks in Oracle Spatial Network Data Model
– Spatial GeoRaster: Manageability, Reliability, Usability Enhancements
– Enhanced Workspace Manager Performance and Data Storage Options
– Enhanced Workspace Manager Security and Administration
– Improved Workspace Manager Valid Time Usability
– Oracle Multimedia Performance and Scalability
– Multimedia DICOM Medical Imaging Format Support
– ORDDicom Object Type
– DICOM Metadata Extraction
– DICOM Conformance Validation
– DICOM Image Processing
– Making DICOM Content Anonymous
– Creation of DICOM Content
– Runtime Updatable DICOM Data Model
– RFID Identity Code Data Type for EPC, DoD, and Custom Sensor Tags
– Improved Performance for Bulk Loading
– Support for Storage and Query of Semantic Content
– ASM Fast Mirror Resync
– ASM Manageability Enhancements
– ASM Preferred Mirror Read
– ASM Rolling Upgrade
– ASM Scalability and Performance Enhancements
– Convert Single-Instance ASM to Clustered ASM
– New SYSASM Privilege for ASM Administration
– Database Replay
– SQL Performance Analyzer
– Advanced Replication Cutover
– ASM Enhancements
– Change Manager – Sync and Propagate
– Database Cloning Enhancements
– Database Configuration (ECM) Collection Enhancements
– Database Home Page and Performance Page Improvements
– DBCA Enhancements
– DBUA Enhancements
– Enhanced Adaptive Metric Thresholds
– Fusion Requirements
– Management of Oracle Text Indexes
– Migrate Database to ASM – Enhancements in Enterprise Manager
– Storage / Audit Report and Metric Enhancement
– Storage: Schema, Security, and Configuration Enhancements
– Wait Activity Detail Enhancement
– Workspace Manager
– ADDM for Oracle Real Application Clusters
– Auto-Task
– Automatic Maintenance Tasks Management
– Automatic Workload Repository (AWR) Baselines
– Database Statistics Model Consolidation
– Enhanced Active Session History
– Enhanced Advisor Framework
– Lightweight Jobs
– Scheduling External Jobs on Multiple Nodes
– Simplified Initialization Parameter Management
– I/O Calibration
– I/O Statistics
– Per Session I/O Limits
– Resource Manager Statistics in AWR
– Resource Plans
– Enhanced Optimal Flexible Architecture (OFA) Support
– AUM Default Setting and Migration Support
– Enhanced Statistics Collection for Partitioned Objects
– Simplified Temp Space Management
– Automatic SQL Tuning with Self-Learning Capabilities
– Enhanced Optimizer Statistics Maintenance
– Multi-Column Statistics
– Partition Advisor
– SQL Plan Management
– Automated Alerts for Streams
– Divergence Detection and Resolution
– Split and Merge of Streams
– Streams Message Tracking
– Streams Performance Advisor
– Streams Topology
– Synchronous Streams Capture
– Direct NFS Client
– Enhanced Partition Pruning Capabilities
– Intelligent Cursor Sharing
– NLS Performance Improvements
– Binding and Defining Multiple Buffers in OCI
– Bitmap Join Index Support for Index-Organized Tables
– Cost-Based Optimizer Enhancements
– Network/OCI Fusion
– OCI Descriptor Array Allocation
– OCI Implicit ROWID Fetching
– PL/SQL Function Result Cache
– PL/SQL Native Compilation Without Needing a Third-Party C Compiler
– Query Result Cache
– ODBC Performance Improvement
– Kerberos Cross Realm Support
– SYSDBA Strong Authentication
– Tablespace Encryption
– Hardware-Based Master Key Protection
– Audit By Default
– Built-in Password Complexity Checker
– Built-in User Profile
– Fine-Grained Access Control on Network Call-outs from the Database
– Improve Security for Network Administration, Registration, and Operation
– Parameters for Enhanced Security of Database Communication
– Support Nonanonymous LDAP Access for Net Naming
– Integrated Database Security Manageability
– Virtual Private Catalog
– Standards-Based Password Algorithm
– Active Directory Security Enhancements
– Volume Shadow Copy Service (VSS) Writer

11gR2
– Application Date Format
– Custom Themes
– Declarative BLOB Support
– Documented JavaScript Libraries
– Enhanced Report Printing
– Forms Conversion
– Improved Security
– Interactive Reporting Region
– Runtime-Only Installation
– Support WITH HOLD Option for CURSOR DECLARATION in Pro*C
– Pro*C Support for 8-Byte Native Numeric Host Variable for INSERT and FETCH
– Pro*COBOL Support for 8-Byte Native Numeric Host Variable for INSERT and FETCH
– JDBC Support for Time Zone Patching
– JDBC Support for SecureFile Zero-Copy LOB I/O and LOB Prefetching
– OCI Support for 8-Byte Integer Bind/Define
– Automatic Block Repair
– Backup to Amazon Simple Storage Service (S3) Using OSB Cloud Computing
– DUPLICATE Without Connection to Target Database
– Enhanced Tablespace Point-In-Time Recovery (TSPITR)
– New DUPLICATE Options
– New SET NEWNAME Clauses and Format Options
– Tablespace Checks in DUPLICATE
– Edition-based Redefinition
– Enhance CREATE or REPLACE TYPE to Allow FORCE
– Fine-Grained Dependencies for Triggers
– IGNORE_ROW_ON_DUPKEY_INDEX Hint for INSERT Statement
– Compressed Table Support in Logical Standby Databases and Oracle LogMiner
– Configurable Real-Time Query Apply Lag Limit
– Integrated Support for Application Failover in a Data Guard Configuration
– Support Up to 30 Standby Databases
– Analytic Functions 2.0
– Recursive WITH Clause
– EXECUTE Privilege for DIRECTORY Objects
– Preprocessing Data for ORACLE_LOADER Access Driver in External Tables
– Allow Virtual Columns in the Primary Key or Foreign Key for Reference Partitioning
– System-Managed Indexes for List Partitioning
– In-Memory Parallel Execution
– Minimal Effort Parallel Execution – Auto Degree of Parallelism (DOP) and Queuing
– The DBMS_PARALLEL_EXECUTE Package
– Significant Performance Improvement of On-Commit Fast Refresh
– Advanced Find Support in Mapping Editor
– Business Intelligence Tool Integration
– Copy and Paste of Operators and Attributes in Mapping Editor
– Current Configuration Dropdown List in Design Center Toolbar
– Enhanced Support for Flat File Imports
– Enhanced Table Function Support
– Experts Available in Editor Menu
– Expression Editing in Operator Edit Dialog
– Grouping and Spotlighting of Objects in Mapping Editor
– Improved Management of Locations Registered in Multiple Control Centers
– Improved User Interface for Managing Locations
– Key Lookup Operator Enhancements
– Mapping Debugger Enhancements
– New JDeveloper-Style User Interface
– Operator References Included in Generated PL/SQL Code
– Quick Mapper
– Repository Browser Changes
– Simplified Oracle Warehouse Builder Repository Upgrades
– Support for Extracting Data From Tables Containing LONG Data Type
– Support for Subqueries in Join Operator
– Configuration Assistants Support New Oracle RAC Features
– Enhanced Cluster Verification Utility
– Integration of Cluster Verification Utility and Oracle Universal Installer
– Cluster Time Service
– Oracle Cluster Registry (OCR) Enhancements
– Grid Plug and Play (GPnP)
– Oracle Restart
– Policy-Based Cluster and Capacity Management
– Improved Clusterware Resource Modeling
– Role-Separated Management
– Agent Development Framework
– Zero Downtime Patching for Oracle Clusterware and Oracle RAC
– Enterprise Manager-Based Clusterware Resource Management
– Enterprise Manager Provisioning for Oracle Clusterware and Oracle Real Application Clusters
– Enterprise Manager Support for Grid Plug and Play
– Enterprise Manager Support for Oracle Restart
– Configuration Assistant Support for Removing Oracle RAC Installations
– Oracle Universal Installer Support for Removing Oracle RAC Installations
– Improved Deinstallation Support With Oracle Universal Installer
– Downgrading Database Configured With DBControl
– Oracle Restart Integration with Oracle Universal Installer
– Out-of-Place Oracle Clusterware Upgrade
– OUI Support for Out-of-Place Oracle Clusterware Upgrade
– Server Control (SRVCTL) Enhancements
– Server Control (SRVCTL) Enhancements to Support Grid Plug and Play
– SRVCTL Support for Single-Instance Database in a Cluster
– Universal Connection Pool (UCP) Integration with Oracle Data Guard
– UCP Integration With Oracle Real Application Clusters
– Universal Connection Pool (UCP) for JDBC
– Java API for Oracle RAC FAN High Availability Events
– Flashback Data Archive Support for DDLs
– Instance Caging
– E-mail Notification
– File Watcher
– Multiple Destination Jobs
– Remote Database Jobs
– Data Pump Legacy Mode
– Complete IPv6 Support for JDBC Thin Clients
– Complete IPv6 Support for JVM and Java Debuggers
– Enterprise Manager Support Workbench for ASM
– XStream
– Database Smart Flash Cache
– Stored Outlines Migration to SQL Plan Management
– Client Result Cache Using Table Annotations Support
– Support 4 KB Sector Disk Drives
– Audit Trail Cleanup
– Tablespace Master Key Rekey
– ASM Cluster File System (ACFS)
– ASM Dynamic Volume Manager (DVM)
– ASM FS Snapshot
– Oracle Cluster Registry (OCR) and Voting Disk on ASM
– ASM Intelligent Data Placement
– ASM Storage Management Configuration Assistant
– Automatic Storage Management (ASM) File Access Control
– ASMCMD Command Extensions
– Enterprise Manager Support for ASM Cluster File System (ACFS)
– Enterprise Manager Integration for ASM File Access Control
– EMCA Supports New Oracle RAC Configuration for Enterprise Manager
– Patch Application with DBControl
– Automatic Patching of Time Stamp With Time Zone Data
– Prevent Data Loss for Time Zone with Local Time Zone Data Type
– Segment Creation on Demand
– Zero-Size Unusable Indexes and Index Partitions
– Metadata SXML Comparison Tool
– Compare Period Report
– Compare SQL Tuning Sets
– Enable Sampling for Active Data Guard
– Oracle Exadata Simulation
– Global Oracle RAC ASH Report + ADDM Backwards Compatibility
– Oracle MTS and Streams Support
– Parallel Query + Alt Plan Recording, Export STS Enhancements
– Synchronization Controls
– Attribute Extraction of Requested Attributes Only
– Client-Side DICOM Attribute Extraction
– DICOM Enhancements
– Watermarking and Image Processing Enhancements
– 3D Visualization Framework
– Network Data Model Enhancements
– New GeoRaster JAVA API
– Raster Reprojections and Ground Control Point-Based (GCP) Georeferencing
– Routing and Geocoding Enhancements
– Database File System (DBFS)
– Support for Oracle SecureFiles
– Binary XML Enhancements
– Oracle XML DB Repository Performance Improvements and Guidelines
– XMLIndex Enhancements
– XMLType Partitioning
– Control File Updates Can Be Disabled During NOLOGGING Operations
– New Package for Configuring Automatic SQL Tuning
– Enhanced Security for DBMS_SCHEDULER E-Mail Notification
– Enhanced TRUNCATE Functionality
– Support for In-Place Upgrade of Clients
– Maintenance Package for Segment Creation on Demand
– Maximum CPU Utilization Limit
– Name Matching
– Named Entity Extraction
– Default Size of First Extent of Any New Segment for a Partitioned Table Has Changed
– Parallel Statement Queuing
– PMML Import
– Result Set Interface
– Segment Creation On Demand for Partitioned Tables
– Simplification of XML and XQuery Interfaces
– SMTP Authentication
– SMTP Encryption
– SPA Support for Active Data Guard Environment
– The EDITION Attribute of a Database Service
– Using Binary XML with SecureFiles as the XMLType Default Storage
– JDBC 4.0 SQLXML
– ID Key LCRs in XStream
– ACFS, ADVM and Snapshots on Solaris and AIX
– Oracle ACFS Replication
– Oracle ACFS Security and Encryption Features
– Oracle ACFS Tagging
– Database QoS Management Server
– Database Quality of Service (QoS) Management Support
– Enterprise Manager QoS Management Integration
– Server Memory Stress Protection for Oracle Clusters
– Database Replay SQL Performance Analyzer (SPA) Integration
– Database Replay Timeout Function
– Database Replay Workload Analyzer
– DBCA Support for Creating an Oracle RAC One Node Database
– Option of Downloading Latest Updates During Installation
– Oracle ASM Configuration Assistant Support for Out-of-Place Upgrades
– Oracle Database Upgrade Assistant Support for Out-of-Place Upgrades
– Oracle Enterprise Manager DB Control Support for Oracle RAC One Node
– Online Relocation of an Oracle RAC One Node Database
– SRVCTL-Based Management of Oracle RAC One Node Databases
– CRSCTL Command Enhancements
– SRVCTL Command Enhancements
– Enhanced XStream Manageability
– Columnar Compression Support in Supplemental Logging and XStream
– Standalone Configuration Wizard for Post-Installation Cluster Configuration
– Redundant Interconnect Usage
– Support Hybrid Columnar Compression on Pillar Axiom and Sun ZFSSA
– Support for SHA-2 Certificate Signatures
– TDE Hardware Acceleration for Solaris
– Support for Multiple Certificates on Smart Card
– QoS Management Support for Oracle RAC Enterprise Edition
– QoS Management Support for Instance Caging on Oracle Exadata
– Oracle ACFS Snapshot Enhancements
– Oracle ACFS Security and Encryption Features
– Support for ACFS Replication and Tagging on Windows
– Oracle LogMiner Support for Binary XML
– SQL Apply Support for Binary XML
– Oracle LogMiner Support for Object Relational Model
– SQL Apply Support for Object Relational Model
– Deprecation of Obsolete Oracle XML DB Functions and Packages
– Oracle Warehouse Builder Support for Partition DML
– Enhanced Partitioning Support in Oracle Warehouse Builder
– Oracle Warehouse Builder External Table Data Pump Support
– Oracle Warehouse Builder External Table Preprocessor Support
– Compressed Table and Partition Support in Oracle Warehouse Builder
– Support for PL/SQL Native Compilation
– Oracle Data Redaction
– Trace File Analyzer and Collector
– RACcheck – The Oracle RAC Configuration Audit Tool
– Database Replay Support for Database Consolidation
– Optimization for Flashback Data Archive History Tables
– Desupported Features
– New sqlnet.ora Parameter SSL_EXTENDED_KEY_USAGE
– New PrimaryLostWriteAction Property
– ENABLE_GOLDENGATE_REPLICATION for Oracle GoldenGate

12cR1
– Accessibility
– Automatic Purging of Workspaces
– Dynamic Actions
– End User Data Upload
– Error Handling
– Expanded Interactive Reports
– Improved Charting Engine
– Mobile Applications
– Modernized Application Builder
– Packaged Applications
– Plug-Ins
– Tabular Forms
– Team Development
– Themes and Templates
– Time Stamp and Time Zone Support
– Use of ROWID
– Web Services Support
– Websheets
– Expanded Database Locale Support
– Replacement of CSSCAN and CSALTER with DMU
– Unicode 6.1 Support
– Unicode Collation Algorithm Conformance
– Import and Export of Workspace Manager Schema
– Performance Improvements to Workspace Operations and Views
– An Invoker’s Rights Function Can Be Result Cached
– An Object of Type LIBRARY Can Be Defined Using an Object of Type DIRECTORY
– Enhanced Oracle Native LEFT OUTER JOIN Syntax
– JDBC Support for PL/SQL Data Types as Parameters
– Mechanism to Restrict the Ability to Reference a PL/SQL Unit to a White List of Database Objects
– Native Client API Support for PL/SQL Package Types and Boolean Types as Parameters
– New PL/SQL DBMS_UTILITY.EXPAND_SQL_TEXT Procedure
– New PL/SQL Package UTL_CALL_STACK
– New Predefined PL/SQL Inquiry Directives
– New SCHEMA Parameter for DBMS_SQL.PARSE() Procedure
– PL/SQL Functions Defined in the SQL WITH Clause
– PL/SQL-Specific Data Types Allowed Across the PL/SQL-to-SQL Interface
– Precompilers Support for SQL Plan Management
– SQLJ Support for SQL Plan Management
– Temporal Validity
– Temporal Validity Flashback Queries
– Auto-Tuning Oracle C Client Interface (OCI) Applications
– Oracle C/C++ Client (OCI/OCCI) Support for Row Count Per Iteration for Array DML
– Default Values for Columns Based on Oracle Sequences
– DEFAULT Values for Columns on Explicit NULL Insertion
– IDENTITY Columns
– Increased Size Limit for VARCHAR2, NVARCHAR2, and RAW Data Types
– JDBC Support for Sybase Applications Migration
– Implicit Result Sets
– Native SQL Support for Query Row Limits and Row Offsets
– Oracle Database Driver for MySQL Applications
– Precompiler Support for Prefetch By Memory
– SQL CROSS APPLY, OUTER APPLY and LATERAL
– SQL Translation Framework
– Microsoft .NET Framework 4 and 4.5 Support
– Oracle TimesTen In-Memory Database
– 64-Bit ODP.NET XCopy for Windows x64
– Entity Framework and LINQ
– Implicit REF CURSOR Parameter Binding
– Oracle SQL Supports APPLY Keyword
– Returning Row Counts
– Windows Communication Foundation (WCF) Data Services and Open Data Protocol (OData)
– JDBC Support for Monitoring Database Operations (DBOP)
– Database Support for JDK Upgrade
– Database Support for Latest Java SE and Standard Utilities
– Enhanced Security for Java in the Database
– JDBC Enhanced Security
– JDBC Support for Database Resident Connection Pool
– JDBC Support for Latest Java Standards
– Decision Tree Mining Text Data
– Expectation Maximization (EM) Clustering and Density Estimation
– Feature Extraction Using Singular Value Decomposition
– Feature Selection and Creation for Generalized Linear Models (GLM)
– Native Double in Data Mining Functions
– Native SQL Support for Row Pattern Matching
– Native Text Support
– On-the-Fly Models
– Prediction Details and Cluster Functions
– Cube Query Performance Enhancements
– Cube Statistics Support
– Asynchronous Global Index Maintenance for DROP and TRUNCATE Partition
– Cascade Functionality for TRUNCATE and EXCHANGE Partition
– Interval Reference Partitioning
– ONLINE Move Partition
– Partial Indexes for Partitioned Tables
– Partition Maintenance Operations on Multiple Partitions
– Adaptive Query Optimization
– Adaptive SQL Plan Management
– Automatic Column Group Detection
– Concurrent Execution of UNION and UNION ALL Branches
– Concurrent Statistics Gathering
– Database Smart Flash Cache Support for Multiple Flash Devices
– Dynamic Statistics
– Enhanced Parallel Statement Queuing
– Enhancements to Incremental Statistics
– Enhancements to System Statistics
– Improved Automatic Degree of Parallelism
– New Types of Optimizer Statistics
– Online Statistics Gathering for Bulk Loads
– Out-of-Place Materialized View Refresh
– Session-Private Statistics for Global Temporary Tables
– SQL Plan Directives
– Synchronous Materialized View Refresh
– Database Hardening: Enable Flashback Data Archive (FDA) for Security-Related Application Tables
– Flashback Data Archive Improvements
– Optimization for Flashback Data Archive History Tables
– Automatic Data Optimization (ADO)
– EXECUTE_ILM Procedure
– Heat Map
– PL/SQL Interface for Managing ADO Policies
– Row-Level Compression Tiering
– Segment-Level Compression Tiering
– In-Database Archiving
– Enable PDML Operations on SecureFiles
– Oracle Data Pump: Support SecureFiles LOB as Default
– SecureFiles is the Default for LOB Storage
– Integrate With Operating System Processor Groups
– Oracle Data Pump Support for Database Consolidation: Full Transportable
– Multitenant Architecture
– PDBs Backup and Recovery
– PDBs Point-in-Time Recovery
– PDBs Resource Plans
– New Job Types
– Cloning a Database
– LOGTIME Parameter for Oracle Data Pump Command
– Oracle Data Pump Audit Commands
– Oracle Data Pump Change Table Compression at Import Time
– Oracle Data Pump Enhanced Compression Options
– Oracle Data Pump Export View As a Table
– Oracle Data Pump No Logging Option for Import
– Oracle Data Pump Security: No-Echo of Encryption Passwords on Export and Import Commands
– SQL*Loader and External Tables: Use dNFS for Accessing Files on NFS Servers
– SQL*Loader Audit Direct Path Loads
– SQL*Loader Express Mode
– Application Continuity for Java
– Transaction Guard
– Support for Extended VARCHAR2 in XStream
– XStream New Apply Parameters
– XStream New Capture Parameters
– XStream Optimized Management of Large Transactions
– XStream Support for Advanced LOB Deduplication
– XStream Support for XML Object Relational and Binary
– Global Data Services (GDS)
– Oracle C/C++ Application High Availability Enhancements
– Oracle ASM Disk Scrubbing
– Editioned and Noneditioned Objects
– Enhanced Online DDL Capabilities
– Invisible Columns
– Lock Timeout for FINISH_REDEF_TABLE
– Metadata-Only DEFAULT Column Values for NULL Columns
– Move a Data File Online
– Multiple Indexes on Same Set of Columns
– Online Redefinition of Multiple Partitions
– Single Command REDEF_TABLE to Redefine Table or Partition
– Support Redefinition of Tables With VPD Policies
– Advanced Data Guard Broker Manageability
– Oracle Data Guard Broker Support for Cascaded Standby Databases
– Fast Sync
– Single Command Role Transitions
– Real-Time Apply is Default Setting for Data Guard
– Resumable Switchover Operations
– Active Data Guard Enhanced Security
– Active Data Guard Support for DML on Global Temporary Tables
– Active Data Guard Support for Sequences
– Active Data Guard Real-Time Cascade
– Active Data Guard Far Sync
– Data Guard Rolling Upgrade Support for Advanced Data Types
– Data Guard Rolling Upgrade Support for XDB Repository
– Disaster Protection During Database Rolling Upgrade
– Oracle Advanced Queuing (AQ) Support for Data Guard Database Rolling Upgrade
– Oracle Data Guard Broker Support for Database Rolling Upgrades
– Oracle Scheduler Support for Data Guard Database Rolling Upgrade
– Rolling Upgrade Using Active Data Guard
– SQL Apply Extended Data Type Support (EDS)
– SQL Apply Support for Objects, Collections, and XMLType
– SQL Apply Support for XMLType
– SQL Apply Support for SecureFiles LOBs
– JMS Bulk Message Purging
– JMS Event-Driven Listener
– JMS Message Priorities, Exception Queues, and Expiration
– JMS Transactional Nonpersistent Queues
– Message Forwarding on Oracle RAC
– AQ Rules Engine Fast Evaluation of SYS_CONTEXT and Other Predicates
– Rules Engine Result Cache
– Sharded Queues for Performance and Scalability
– Simplified Metadata and Schema
– Active Database Duplication Enhancements
– Cross-Platform Backup and Restore
– DUPLICATE Enhancements
– Multisection Image Copies
– Multisection Incremental Backups
– Network-Enabled RESTORE
– RMAN Command-Line Interface Enhancements
– Storage Snapshot Optimization
– Table-Level Recovery From Backups
– Enterprise Manager Database Express
– PGA Size Limit
– Real-Time Database Operations Monitoring
– Resource Manager Runaway Query Management
– Spot ADDM
– Mask At Source or Mask During Subset
– Self Update for Oracle Applications Masking and Subsetting Templates
– Database Replay Support for Database Consolidation
– Database Replay Workload Scale-Up and Characterization
– Enhanced Database Replay Reporting
– Queryable Patch Inventory
– Oracle Flex ASM
– Oracle ASM Shared Password File in a Disk Group
– Oracle ASM Rebalance Enhancements
– Oracle ASM Disk Resync Enhancements
– Oracle ASM chown, chgrp, chmod and Open Files Support
– Oracle ASM Support ALTER DISKGROUP REPLACE USER
– Enterprise Manager Support for Oracle ASM Features
– Oracle ASM File Access Control on Windows
– Oracle Grid Infrastructure Rolling Migration for One-Off Patches
– Oracle ACFS Support for All Oracle Database Files
– Oracle ACFS and Highly Available NFS
– Oracle ACFS Snapshots Enhancements
– Oracle ACFS Replication Integration with Oracle ACFS Security and Encryption
– Oracle Audit Vault and Database Firewall Support for Oracle ACFS Security and Encryption
– Oracle ACFS Security and Encryption Features
– Oracle ACFS File Tags for Grid Homes
– Oracle ACFS Plug-in APIs
– Enterprise Manager Support for Oracle ACFS New Features
– Oracle ACFS Replication and Tagging on AIX
– Oracle ACFS Replication and Tagging on Solaris
– Oracle Flex Cluster
– Policy-Based Cluster Management and Administration
– What-If Command Evaluation
– Oracle Cluster Registry Backup in ASM Disk Group Support
– Shared Grid Naming Service (GNS)
– SRVCTL Support for Oracle Flex Cluster Implementations
– Online Resource Attribute Modification
– Grid Infrastructure Script Automation for Installation and Upgrade
– Multipurpose Cluster Installation Support
– Support for IPv6 Based IP Addresses for Oracle RAC Client Connectivity
– Advanced Network Compression
– Very Large Network Buffers
– Asynchronous I/O Control for Direct NFS Client
– Tracking I/O Outliers
– Multi-Process Multi-Threaded Oracle
– Ability to Specify NFS Version in Direct NFS Client
– Oracle Data Redaction
– Support for Secure Hash Algorithm SHA-2 in Oracle Database
– Auditing Enabled By Default
– Code-Based Security
– Data Guard Support for Separation of Duty (SoD)
– Enhanced Security of Audit Data
– Increased Security When Using SELECT ANY DICTIONARY
– Last Login Time Information
– Oracle Database Vault Mandatory Realms
– Oracle Label Security Metadata Export and Import
– Password Complexity Check
– Privilege Analysis
– Resource Role Default Privileges
– Separation of Duty for Audit Administration
– Separation of Duty for Database Administration
– SYSBACKUP Administration Privilege
– Updated Key Management Framework
– Oracle Database Vault Persistent Protections
– Simplified Oracle Database Vault and Oracle Label Security Installation
– Transparent Sensitive Data Protection
– VPD Fine-Grained Context-Sensitive Policies
– Restricted Service Registration for Oracle RAC
– Real Application Security
– Unified Context-Based Database Audit Architecture
– Vector Performance Acceleration
– Spatial Routing Engine Enhancements
– Spatial GeoRaster – Raster Algebra and Analytics
– Spatial GeoRaster – Enhanced Image Processing
– Spatial GeoRaster – Java API Enhancements
– Spatial GeoRaster – New Metadata Content
– Network Data Model Graph – Feature Modeling and Analysis
– Network Data Model Graph – Temporal Modeling and Analysis
– RDF Views on Relational Tables
– RDF Semantic Graph Named Graph Support
– Support for Analytic Operations and Tools
– RDF Semantic Graph Support for XML Schema, Text and Spatial Data Types
– RDF Semantic Graph Document Indexing Enhancements
– RDF Semantic Graph Support for W3C and OGC Standards, Open Source, and Third-Party Technologies
– DICOM Protocol Support for Oracle Database
– Integrating Oracle Multimedia DICOM with Oracle WebCenter Content
– Full Mode Database Import and Export for Oracle Multimedia
– Near Real-Time Indexing
– Automatic Management of Near Real-Time Indexes
– BIG_IO Large TOKEN_INFO Option
– Separate Offsets
– Updatable SDATA Sections
– Add SDATA Section to Existing Index
– Ordering by SDATA Sections
– Increased Number of Field Sections
– Document-Level Lexer
– Increased Number of MDATA Sections
– Language Identification
– BIGRAM Mode for the Japanese VGRAM Lexer
– Mild Not (MNOT) Operator
– Forward Index
– NEAR Operator Enhancements
– Pattern Stopclass
– Session-Duration SQEs
– Query Filter Cache
– Snippet Support in Result Set Interface
– Enhanced ANYDATA Support
– Integrated Oracle XQuery Implementation
– Oracle XDK/J DOM Improvements
– Domain Index Support of Hash Partitioned Tables
– Oracle XSLT or XPath Engine Interoperability
– Programmatically Create and Manipulate Scalable DOM
– Standalone XQuery Virtual Machine
– Support XQuery Full-Text Specification
– XDK/J Support for Fast Infoset
– XmlDiff Support for XDK Java
– Support for XQuery Update
– Enable Digest Authentication with Oracle Database HTTP Listener
– WebDAV, HTTP, and FTP Access for DBFS
– Enhanced Upgrade Automation
– Parallel Upgrade
– Support for Oracle Home User on Windows
– Support of Oracle Home User for Oracle Net Services
– Named User Support for Oracle RAC Services on Windows
– Advanced Index Compression
– Approximate Count Distinct
– Attribute Clustering
– Automatic Big Table Caching
– FDA Support for CDBs
– Full Database Caching
– In-Memory Aggregation
– In-Memory Column Store
– JSON Support
– New FIPS 140 Parameter for Encryption
– PDB CONTAINERS Clause
– PDB File Placement in OMF
– PDB Logging Clause
– PDB Metadata Clone
– PDB Remote Clone
– PDB Snapshot Cloning Additional Platform Support
– PDB STANDBYS Clause
– PDB State Management Across CDB Restart
– PDB Subset Cloning
– Rapid Home Provisioning
– Zone Maps

12cR2
– Application Express 5.0: Packaged Applications
– Application Express 5.0: Page Designer
– Application Express 5.0: Universal Theme
– Application Express 5.0: User Interface Enhancements
– Application Express 5.0: Improved Application Builder Design
– Application Express 5.0: Interactive Reporting
– Application Express 5.0: Mobile Enhancements
– Application Express 5.0: Modal Dialog Pages
– Application Express 5.0: All New Calendar
– SQL*Plus Command History
– SQL*Plus Tuning Options
– Extensible Indexing Enhancements
– Column-Level Collation
– Case-Insensitive Database
– AL32UTF8 As the Default Database Character Set
– Unicode 7.0 Support
– JSON Improvements
– PL/Scope Reports on Static SQL Statements and Call Sites for Dynamic SQL
– Enhancing CAST Function With Error Handling
– New SQL and PL/SQL Function VALIDATE_CONVERSION
– Binding PL/SQL-Only Data Types to SQL Statements Using DBMS_SQL
– Improving the PL/SQL Debugger
– New PL/SQL Pragma to Mark an Item as Deprecated
– Materialized Views: Real-Time Materialized Views
– Materialized Views: Statement-Level Refresh
– Enhancing LISTAGG Functionality
– DBMS_PLSQL_CODE_COVERAGE Package
– Approximate Query Processing
– White Lists (ACCESSIBLE BY) Enhancements
– Long Identifiers
– Oracle Java Virtual Machine Support for Long Identifiers
– Static PL/SQL Expressions Now Allowed Where Previously Literals Were Required
– Longer Schema Identifiers for Oracle Data Provider for .NET
– Real Application Clusters Connection Node Affinity
– Entity Framework Code First Enhancements
– .NET Cloud Development and Deployment
– ODP.NET Managed Driver
– Longer Schema Identifiers for Oracle Provider for OLE DB
– Multi-Property Labeling of DRCP Servers
– PL/SQL Callback Facility for Session State Fix Up
– New MAX_TXN_THINK_TIME Setting for DRCP Pooled Servers With Transactions in Progress
– Proxy Session Sharing in DRCP
– DRCP Statistics Views and AWR Reports for Performance Monitoring and Tuning
– JDBC Support for Binding PLSQL_BOOLEAN
– Oracle JDBC Support for JDK 8 and JDBC 4.2
– Oracle Universal Connection Pool (UCP) Configuration Using XML
– Universal Connection Pool Health Check Frequency
– JDBC Support for Deprioritization of Database Node
– Oracle Java Virtual Machine (OJVM) Web Services Callout
– OJVM Support for Java SE 8
– JavaScript Stored Procedures Using Java 8 Nashorn
– Enhancing the Oracle XML Developers Kit for Java (XDK/J)
– Loading Sub-Documents from XML Documents Using ORACLE_LOADER
– Distributed Operations on CLOB, BLOB and XMLType
– OCI Support for Distributed LOBs
– Minimizing Impact on Primary Database When Using Multiple SYNC Standby Databases
– Oracle Data Guard Database Compare
– Subset Standby
– Oracle Data Guard Broker Support for Multiple Automatic Failover Targets
– Oracle Data Guard Broker Support for Multiple Observers
– Simplifying Observer Management for Multiple Fast-Start Failover Configurations
– Oracle Data Guard Broker Support for Transport Destinations of Different Endianess Than the Primary
– Oracle Data Guard Broker Support for Oracle Data Guard Multiple Instance Apply
– Oracle Data Guard Broker Support for Enhanced Alternate Destination
– Fast-Start Failover in Maximum Protection Mode
– Block Comparison Tool Support in Oracle Data Guard Broker DGMGRL Interface
– Oracle Data Guard Broker Support for Executing DGMGRL Command Scripts
– Broker ConfigurationWideServiceName Configuration Property
– Enhancing Support for Alternate Destinations
– Automatically Synchronize Password Files in Oracle Data Guard Configurations
– Preserving Application Connections to An Active Data Guard Standby During Role Changes
– Application Continuity for OCI Applications
– Application Continuity
– Transaction Guard for Oracle XA Transactions
– Java Support for FAN APIs (UP, DOWN and LoadAdvisory Events)
– JDBC Driver Support for Fast Application Notification (FAN)
– Support for Planned Outages
– Planned Outage for Oracle Data Guard Switchover and Oracle RAC One Node
– Application Continuity for Planned Database Maintenance
– Multi-Instance Redo Apply
– Oracle Data Guard for Data Warehouses
– Data Guard Broker PDB Migration or Failover
– Error Handling Improvements for Oracle GoldenGate Integrated Replicat
– Abstract Data Types Support
– Oracle GoldenGate Annotations for DDL
– XStream Inbound Server Performance Optimizations
– Restarting Redefinition From Failure
– Rolling Back Redefinition
– Redefinition Progress Monitoring
– Optimizing Batch Update During Redefinition
– Materialized Views: Fast Dependent Materialized View Refresh During Redefinition
– Redefinition Supports Tables With BFILE Columns
– Formalizing Retirement of an Edition With Automatic Garbage Collection
– Online Conversion of a Nonpartitioned Table to a Partitioned Table
– Online SPLIT Partition and Subpartition
– Online Table Move
– Partitioning: Table Creation for Partition Exchange
– Partitioning: Filtered Partition Maintenance Operations
– RMAN: Syntax Enhancements
– SCAN Listener Supports HTTP Protocol
– Oracle Recovery Manager – Enhanced Table Recoveries Across Schemas Using REMAP SCHEMA
– Disk Space Check During RECOVER TABLE Operation
– Upgrading the Incremental Transportable Scripts
– Cross-Platform Import of a Pluggable Database into a Multitenant Container Database
– Cross-Platform Migration Support for Encrypted Tablespaces
– Cross-Platform Support Over The Network
– Data Guard DUPLICATE Command Enhancements
– DUPLICATE Command Support for Non Auto-Login Wallet Based Encrypted Backups
– Oracle Database Sharding
– Data-Dependent Routing
– Automatic Deployment of Oracle Data Guard
– Creating Data Guard Standbys With Database Configuration Assistant
– Statement-Level Routing and Cross-Shard Queries
– Enhancing SSL and Kerberos Authentication for Administrative Users
– Oracle Label Security Support for Oracle Data Guard Database Rolling Upgrade
– Oracle Database Vault Support for Oracle Data Guard Database Rolling Upgrade
– Oracle Database Vault Support for Flashback Technology and ILM
– Oracle Data Guard Broker Support for Oracle Active Data Guard Rolling Upgrades
– Partitioning: External Tables
– Enhancing Declarative Constraint Support
– Oracle Parallel Query Services on Oracle RAC Read-Only Nodes
– External Tables Can Access Data Stored in Hadoop Data Sources Including HDFS and Hive
– Analytic Views
– Optimizer Statistics Advisor
– Enhancing SQL Plan Management
– Scan Rate and In-Memory Columnar Statistics
– Band Join Enhancements
– Parallel Recursive WITH Enhancements
– Cursor-Duration Temporary Tables Cached in Memory
– Local TEMP Tablespaces
– Oracle Database Can Contain Both Read/Write and Read-Only Instances
– Oracle Advanced Analytics Extensibility for R Models
– Oracle Advanced Analytics Association Rules Enhancements
– Significant Performance Improvements and Support for Partitioned Models
– Explicit Semantic Analysis Algorithm Enhancement
– Support for Range-Based XML Queries with Text-Based XML Index
– Improving Token Management for Binary XML
– Partitioning: Improving Support for XMLIndex
– SMALL_R_ROW Support
– Text: Reverse Token Index for Left-Truncated Queries
– Support for 30-Character Index Names
– NFS Server in Database
– HCC Compression for Array Inserts
– HCC Compress Data With ADO Row-Level Policy
– Advanced Index Compression
– Oracle Grid Infrastructure Installation Using Zip Images
– Text: Partition-Specific Near Real-Time Indexes
– Text: Improving Management of Near Real-Time Indexes
– Partitioning: Auto-List Partitioning
– Fine-Grained Cursor Invalidation
– Text: Adding New Document Formats
– Text: Structured/Sort Data (SDATA) Section Improvements
– Text: Availability of Updated Documents in Index
– Text: Read-Only MDATA Sections
– Text: Sentiment Analysis and Collocates
– Text: Join Character Support for JAPANESE_VGRAM_LEXER and WORLD_LEXER
– Text: Extracting Synonyms of Words in Documents
– Text: Changes to NDATA, NEAR2, and NESTED NEAR Query Operators
– Materialized Views: Refresh Statistics History
– Process Management
– Partitioning: Read-Only Partitions
– Partitioning: Multi-Column List Partitioning
– JDBC Support for BigSCN
– Parameter Default and File Location Changes for Read-Only Oracle Home for Oracle Text
– I/O Rate Limits for PDBs
– Heat Map and Automatic Data Optimization Support for CDBs
– PDB Character Set
– PDB Refresh
– Hints in CONTAINERS Query
– Parallel PDB Creation Clause
– PDB Archive Files (.pdb Files)
– Default Tablespace Clause
– Cloning a PDB
– Near Zero Downtime PDB Relocation
– Logical Standby Database to Support CDBs with PDBs with Different Character Sets
– LogMiner to Support CDBs with PDBs with Different Character Sets
– Support for PDBs with Different Character Sets, Time Zone File Versions, and Database Time Zones in a CDB
– Memory Resource Management
– Per-Process PGA Limits
– Performance Profiles and Mandatory PDB Profiles
– CDB-Level PDB Lockdown
– Application Root
– Proxy PDB
– Forwarding Connections to A New Address Based on Service
– Service-Level ACLs for TCP Protocol
– Flashback Pluggable Database
– Upgrading a CDB With One or More PDBs in a Single Operation
– Support for Thousands of Pluggable Databases for Each Multitenant Container Database
– Pluggable Database Lockdown Profiles Enhancements
– Pluggable Database Operating System Credentials
– Enhancing Ease-of-Use and Reporting From Pre-Upgrade Information Tool
– Automatically Set User Tablespaces to Read-Only During Upgrade
– Scheduler: Job Incompatibilities
– Scheduler: Resource Queues
– Scheduler: In-Memory Jobs
– Oracle Data Pump Parallel Import of Metadata
– Oracle Data Pump Parallel Export of Metadata
– New Options for Substitution Variables in Oracle Data Pump File Names
– Renaming Data Files During Import
– TRUST_EXISTING_TABLE_PARTITIONS Flag for DATA_OPTIONS Parameter of Import
– GROUP_PARTITION_TABLE_DATA Flag for DATA_OPTIONS Parameter of Export
– Data Verification Option to Import, ORACLE_LOADER Access Driver and OCIDirPath
– ORACLE_DATAPUMP and ORACLE_LOADER Access Driver Supports New File Format
– Support for Tables With LONG Data Types in Data Pump Network Mode Operations
– Metadata Transforms Available for Oracle Data Pump in New Views
– Adding Oracle Data Pump and SQL*Loader Utilities to Instant Client
– SDF_PREFIX Parameter for SQL*Loader
– Allowing Multi-Byte Strings for SQL*Loader Parameters Used for Express Mode
– Database Migrations: Support LLS Files Generated by DB2 Export Utility
– Trace File Analyzer: Web-Based Visualization
– Trace File Analyzer: Optimizing Diagnostic Collection
– Trace File Analyzer: Automating Diagnostic Collection
– Trace File Analyzer: Managing Diagnostic Collection
– Trace File Analyzer: Feedback to Auxiliary Systems
– XStream: Replication Event View
– XStream and GoldenGate Inbound Server Message Tracking
– Trace File Analyzer: Enabling Time-Trimmed Diagnostic Collection
– RMAN: Backing Up Sparse Databases in the Backup-Set Format
– RMAN: Backing Up Sparse Databases in the Image Copy Format
– RMAN: Restoring From Sparse Backups
– RMAN: Recovering the Sparse Database
– RMAN: Purging Sparse Backups
– Oracle Data Guard Support for Oracle Diagnostics Pack
– Active Data Guard Support for SQL Tuning Advisor
– SQL Performance Analyzer and SQL Tuning Sets Enhancements
– Database Replay Enhanced PL/SQL Support
– Tracking Index Usage
– Oracle Enterprise Manager Database Express (EM Express) Resource Manager Support
– EM Express: SQL Performance Analyzer (SPA) Support
– EM Express: Simplifying Configuration for Multitenant Through Single Port Access
– EM Express: Performance Hub Enhancements
– Oracle Enterprise Manager Database Express (EM Express) Support for Simplified Database Resource Management
– Automatic Workload Repository (AWR) Support for a Pluggable Database (PDB)
– Monitoring Real-Time Database Operations
– Selective PDB Upgrades
– AWR_PDB_AUTOFLUSH_ENABLED Initialization Parameter
– ENABLE_AUTOMATIC_MAINTENANCE_PDB Initialization Parameter
– AUTOTASK_MAX_ACTIVE_PDBS Initialization Parameter
– Advanced Queuing: PL/SQL Enqueue and Dequeue Support for JMS Payload in Sharded Queues
– Advanced Queuing: PL/SQL Enqueue and Dequeue Support for Non-JMS Payload in Sharded Queues
– ZFS Analytics
– ExaDirect SQL*Net Adapter
– Direct NFS Client Supports Parallel NFS
– Direct NFS Client Dispatcher Support
– Global and Shared Connection Pool for Oracle Cloud and Multitenant Oracle Databases
– Oracle Database Java Virtual Machine Performance Enhancements
– In-Memory Expressions
– In-Memory Virtual Columns
– In-Memory FastStart
– Automatic Data Optimization Support for In-Memory Column Store
– Join Groups
– Expression Tracking
– Oracle Database In-Memory Support on Oracle Active Data Guard
– In-Memory Column Store Dynamic Resizing
– Oracle Database File System File Locking
– Oracle Multimedia PL/SQL API
– Direct SQL*Net Access Over Oracle Cloud
– Controlling Outbound Database Link Options
– Oracle Flex ASM Disk Group Quota Management
– Prioritized Rebalancing
– Extending Oracle Real Application Clusters (Oracle RAC) Configuration Support
– I/O Server
– Cluster Resource Activity Log
– Cluster Verification Utility – Second Generation Command Line Output
– Switch Service Enhancement
– VM Manager Agent for GI
– Shared Grid Naming Service High Availability
– Oracle Clusterware Resource Groups
– Reasoned What-If Command Evaluation (Why-If)
– Server Weight-Based Node Eviction
– Load-Aware Resource Placement
– Oracle Clusterware Application Clusters
– Oracle Grid Infrastructure Installation Support for Application Cluster Installation Type
– Oracle Automatic Storage Management Cluster File System (Oracle ACFS) Snapshot Enhancements
– Oracle ACFS System Defragger
– 4K Sectors and Metadata Enhancements for Oracle ACFS
– Oracle ACFS Metadata Collection Enhancements
– Oracle ACFS Plug-ins for File Content
– Oracle ACFS Loopback Device
– Oracle ACFS API Access for Snapshots, File Tags, Plug-in Metrics
– Oracle ACFS Compression Enhancements
– Oracle Snapshot-Based Replication Enhancements
– Oracle ACFS Auto-Resize Enhancements
– Oracle ACFS Sparse Files Enhancements
– Oracle ACFS Metadata Acceleration
– Oracle ACFS NAS Maximum Availability eXtensions
– Rapid Home Provisioning
– Support for IPv6 Based IP Addresses for the Oracle Cluster Interconnect
– Oracle Real Application Clusters (Oracle RAC) Reader Nodes
– Service-Oriented Buffer Cache Access Optimization
– TDE Tablespace Live Conversion
– Fully Encrypted Database
– Support for ARIA, SEED, and GOST Encryption Algorithms in TDE
– TDE Tablespace Offline Conversion
– RAS Session Privilege Scoping
– RAS Column Privilege Enhancements
– RAS Schema Level Policy Administration
– RAS Integration with OLS
– Oracle Virtual Private Database Predicate Audit
– Oracle Database Vault Policy
– Oracle Database Vault Simulation Mode Protection
– Oracle Database Vault Common Realms and Command Rules for Oracle Multitenant
– Privilege Analysis Enhancements
– Privilege Analysis Results Comparison
– Redaction: Different Data Redaction Policy Expressions
– Redaction: New Functions Allowed in Data Redaction Policy Expressions
– Redaction: Additional Data Redaction Transformations
– Automatic KDC Discovery When Configuring OCI Clients
– Automatic Provisioning of Kerberos Keytab for Oracle Databases
– Role-Based Conditional Auditing
– Inherit Remote Privileges
– SYSRAC – Separation of Duty for Administering Real Application Clusters
– Transparent Sensitive Data Protection Feature Integration
– Requiring Strong Password Verifiers by Default
– Automatic Locking of Inactive User Accounts
– Kerberos-Based Authentication for Direct NFS
– RDF Semantic Graph Support for W3C Standards
– Property Graph Support
– Extending JSON Support in Oracle Database With Spatial Operations
– Location Data Enrichment Services
– In-Database Location Tracking Data Model and Services
– Network Data Model Support for Oracle Coherence
– Network Data Model Feature Editing APIs
– Time-Based Routing Engine Enhancements
– Support for Hash and List Partitioning of Spatial Indexes
– GeoRaster Map Algebra and Image Processing Enhancements
– Spatial Map Visualization
– Open Geospatial Consortium Web Map Service and Web Map Tile Service Support
– Geospatial Consortium Web Coverage Service 2.0 Support
– Oracle Workspace Manager Enhancements
– Windows Group Managed Service Accounts
– Windows Virtual Accounts
– Windows Resilient File System
– Windows Install: Support Virtual Accounts and Group Managed Accounts
– Microsoft Management Console Can Manage Oracle Database
– Windows Direct NFS Client Supports All Widely Accepted NFS Path Formats

Fontes:
https://docs.oracle.com/cd/B28359_01/server.111/b28279/chapter1.htm#NEWFTCH1
https://docs.oracle.com/cd/E11882_01/server.112/e41360/chapter1.htm#NEWFT107
https://docs.oracle.com/cd/E11882_01/server.112/e41360/chapter1_2.htm#NEWFT297
https://docs.oracle.com/cd/E11882_01/server.112/e41360/chapter1_11203.htm#NEWFT355
https://docs.oracle.com/cd/E11882_01/server.112/e41360/chapter1_11204.htm#NEWFT379
https://docs.oracle.com/database/121/NEWFT/chapter12101.htm#NEWFT002
https://docs.oracle.com/database/121/NEWFT/chapter12102.htm#NEWFT003
https://docs.oracle.com/database/122/NEWFT/new-features.htm#NEWFT-GUID-3A8E2A84-4ACB-4354-9DB1-53EE6F608F6D

Leave a Reply

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

This site uses Akismet to reduce spam. Learn how your comment data is processed.