Now official list of Oracle 11g new features is published. Here is page that contains more technical information on Oracle 11g.
Based on new features list I choose some that are very useful in project that I'm work now on, and I see them as important:
Binary XML storage and XML path indexing for schema-less XML documents
Result caches: improves speed of repeated execution of queries and function
calls that access read-only or read-mostly data.
Database Resident Connection Pooling: enables faster connections to the
database for application, that do not provide connection pooling (ex. PHP).
- Faster triggers, including more-efficient invocations of per-row triggers
- Faster simple SQL operations
- SecureFiles: ti's new solution for storing large objects (LOBs) and datatypes such as XML
Automatic compilation for PL/SQL and Java in the database: new “native”
compilation of PL/SQL that do not need C compiler.
New features that look interesting, and I want to play with them:
- Semantic Technologies: native support for Resource Description Framework (RDF) and Web Ontology Language (OWL) standards,
- Oracle Spatial enhancements: Richer, more-interactive map application development
New partitioning capabilities:
- Partitioning by parent/child references,
- Partitioning by virtual columns,
- More composite partitioning options, including range/range, list/range, list/hash, and list/list,
- Interval partitioning, which allows you to automatically create new partitions based on intervals, such as every month or every day,
- Oracle Flashback Data Archive: enables fast query access to old versions of the data.
- Expanded support for standards, such as XML Query (XQuery) 1.0 and service-oriented architecture (SOA)
I'm waiting for Oracle 11g to be available for download...