Improved optimization
Optimizer predictions for decision support operations are compared with actual results, and there will be subsequent adjustments in future predictions if indicated.
MODEL clause
This clause in the SELECT statement allows relational data in a query to be treated as a multidimensional array, which can also have formulas applied to them.
Cross-platform transportable tablespaces
Transportable tablespaces can be used to move data between different operating system platforms.
Downstream capture of change information
Change information can be captured from log files, rather than from the database.
Data Pump
This is a high-speed data transfer application.
Data mining enhancements
These enhancements include text mining and BLAST similarity searches.
Additional analytics and statistics
The database includes new hypothesis testing and distribution statistics, crosstabs, and descriptive statistics. The OLAP option adds support for custom members and measures.