06/03/2017
Pessoal , realmente a Oracle quer vir com tudo com o 12c release 2. Pelo que vi , segue abaixo a lista nova de recursos;
Uma coisa bem legal será Oracle Rac com alguns nós somente leitura. Veja :
SQL*Plus Command History
SQL*Plus Tuning Options
PL/Scope Reports on Static SQL Statements and Call Sites for Dynamic SQL
New SQL and PL/SQL Function VALIDATE_CONVERSION
Materialized Views: Real-Time Materialized Views
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
Fast-Start Failover in Maximum Protection Mode
Automatically Synchronize Password Files in Oracle Data Guard Configurations
Preserving Application Connections to An Active Data Guard Standby During Role Changes
Multi-Instance Redo Apply
Oracle Data Guard for Data Warehouses
Data Guard Broker PDB Migration or Failover
Restarting Redefinition From Failure
Optimizing Batch Update During Redefinition
Online Conversion of a Nonpartitioned Table to a Partitioned Table
Online SPLIT Partition and Subpartition
Online Table Move
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 Support Over The Network
Oracle Database Sharding
Automatic Deployment of Oracle Data Guard
Creating Data Guard Standbys With Database Creation Assistant
Statement-Level Routing and Cross-Shard Queries
Oracle Label Security Support for Oracle Data Guard Database Rolling Upgrade
Oracle Database Vault Support for Oracle Data Guard Database Rolling Upgrade
Oracle Data Guard Broker Support for Oracle Active Data Guard Rolling Upgrades
Oracle Parallel Query Services on Oracle RAC Read-Only Nodes
External Tables Can Access Data Stored in Hadoop Data Sources Including HDFS and Hive
Optimizer Statistics Advisor
Enhancing SQL Plan Management
Scan Rate and In-Memory Columnar Statistics
Local TEMP Tablespaces
Oracle Database Can Contain Both Read/Write and Read-Only Instances
NFS Server in Database
HCC Compress Data With ADO Row-Level Policy
Oracle Grid Infrastructure Installation Using Zip Images
Process Management
Partitioning: Read-Only Partitions
Heat Map and Automatic Data Optimization Support for CDBs
PDB Character Set
PDB Refresh
PDB Archive Files (.pdb Files)
Cloning a PDB
Near Zero Downtime PDB Relocation
Logical Standby Database to Support CDBs with PDBs with Different Character Sets
Memory Resource Management
Performance Profiles and Mandatory PDB Profiles
Proxy PDB
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 Operating System Credentials
Scheduler: In-Memory Jobs
Trace File Analyzer: Web-Based Visualization
RMAN: Backing Up Sparse Databases in the Backup-Set Format
Oracle Data Guard Support for Oracle Diagnostics Pack
Active Data Guard Support for SQL Tuning Advisor
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
Automatic Workload Repository (AWR) Support for a Pluggable Database (PDB)
Monitoring Real-Time Database Operations
Selective PDB Upgrades
Global and Shared Connection Pool for Oracle Cloud and Multitenant Oracle Databases
In-Memory FastStart
Automatic Data Optimization Support for In-Memory Column Store
Oracle Database In-Memory Support on Oracle Active Data Guard
In-Memory Column Store Dynamic Resizing
Prioritized Rebalancing
Extending Oracle Real Application Clusters (Oracle RAC) Configuration Support
Oracle Clusterware Resource Groups
Reasoned What-If Command Evaluation (Why-If)
Server Weight-Based Node Eviction
Oracle Clusterware Application Clusters
Oracle ACFS System Defragger
Oracle ACFS Auto-Resize Enhancements
Oracle ACFS Metadata Acceleration
Support for IPv6 Based IP Addresses for the Oracle Cluster Interconnect
Oracle Real Application Clusters (Oracle RAC) Reader Nodes
TDE Tablespace Live Conversion
Fully Encrypted Database
RAS Integration with OLS
Oracle Virtual Private Database Predicate Audit
Oracle Database Vault Common Realms and Command Rules for Oracle Multitenant
Role-Based Conditional Auditing
Inherit Remote Privileges
SYSRAC – Separation of Duty for Administering Real Application Clusters
Automatic Locking of Inactive User Accounts
Windows Install: Support Virtual Accounts and Group Managed Accounts
Microsoft Management Console Can Manage Oracle Database
