Some new features in 11g

1、Client-Side Query Cache
This feature enables caching of query result sets in client memory. The cached result set data is transparently kept consistent with any changes done on the server side.Applications leveraging this feature see improved performance for queries which have a cache hit. Additionally, a query serviced by the cache avoids round trips to the server for sending the query and fetching the results. It also reduces the server CPU that would have been consumed for processing the query, thereby improving server scalability.

[@more@]

2、OCI Client Session NLS Character Set Status Information
This new feature adds client session NLS and character set information to the V$SESSION_CONNECT_INFO and GV$SESSION_CONNECT_INFO views.
This enhancement provides DBAs with access to client-side session character set information for all clients. This information is especially useful in troubleshooting problems.

3、DECLARE n NUMBER := Seq.Nextval;BEGIN

4、CONTINUE Statement

5、DDL With the WAIT Option

6、Enhanced ADD COLUMN Functionality

7、Finer Grained Dependencies