Oracle Database 11g New Features

Oracle announced the lots of new features which could be part of new release of Oracle 11g Database and I have listed few key features are as follows.

• Query result-set caching as opposite to Data block
• Native Compilation no longer requires a C compiler to compile your PL/SQL. Your code goes directly to a shared library.
• Server side connection pooling (multiple Oracle clients to share a server-side pool of sessions, but USERIDs should match)
• Faster optimizer stats creation
• Interval partitioning, a partitioning scheme that automatically creates time-based partitions as new data is added.
• Interval partitioning, a partitioning scheme that automatically creates time-based partitions as new data is added.
• Virtual columns, columns that are actually functions and similarly, virtual indexes that are based on functions
• REF partitioning, allowing you to partition a table based on the partition scheme of another. Allows you to partition an order_items table based off of the order_date column in an orders table.
• New Oracle11g Advisors - New 11g Oracle Streams Performance Advisor and Partitioning Advisor.
• Faster DML triggers
• Capture/replay database workloads – We can capture the workload in prod and apply it in development
• Enhanced Read only tables
• Table trigger firing order - Oracle 11g PL/SQL will you to specify trigger firing order.
• New table Data Type "simple_integer"
  

I apologize for any typos or spelling errors in my blogs.

-thiru