ITPub博客

首页 > 数据库 > Oracle > Some new features in 11g

Some new features in 11g

原创 Oracle 作者:shiyihai 时间:2007-11-22 13:35:30 0 删除 编辑

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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/38542/viewspace-983286/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    235
  • 访问量
    1667357