Excuse my dust – work in progress
Oracle 12.1 New Features
- Increased size to 32k for varchar2
- Partial indexes on partitioned tables – index only the segments/partitions you still use
- Invisible columns and multiple indexes on the same column
- Fetch first x rows / Top-N
- Pluggable databases and containers that hold them
- Oracle Cloud database as a service DaaS
- Change compression at import time
- Adaptive Query Optimization
- PGA_AGGREGATE_LIMIT
- Concurrent execution for Union/Union All
- db_big_table_cache_p
ercent_target – new parameter changes SGA Buffer Cache algorithm - Invokers rights functions can be Results Cached
- New DBMS_UTILITY.EXPAND_SQL_TEXT – shows text behind sql expanding views
- Defaults for columns based on sequence – identity columns
- Interval Reference Partitioning – new partitions added at defined intervals now supported for reference partitions
- Multiple SSDs devices for Smart Flash Cache
- Concurrent cost-based optimizer statistics gathering – finally
- Enhanced System Statistics
- -Automatic Column Group Detection
- -Statistics Feedback
- -Concurrent Statistics Collection
- -Dynamic Statistics
- -Enhancements to Incremental Statistics
- -Enhancements to System Statistics
- -Histogram Enhancements
- -Online Statistics Gathering for Bulk Loads
- -Session-Private Statistics for Global Temporary Tables
- -SQL Plan Directives
- -New DBMS_STATS Preferences
- Resource Manager
- -Runaway Query Management – Automatic Consumer Group Switching
- -V$SQL_MONITOR
- -Resource Manager with Container Databases (CDB) and Pluggable Databases (PDB)
- Real-Time SQL Monitoring enhancements
- Batch Operation Monitoring
dbms_sql_monitor.begin_operation ( dbop_name => ‘myBatchProc’, forced_tracking => dbms_sql_monitor.force_tracking );
multiple sql statements…
dbms_sql_monitor.end_operation ( dbop_name => ‘myBatchProc’);
From the Database Express 12c Performance menu > Performance Hub > Monitored SQL
This list is incomplete a work in progress… stay tuned