eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« Oracle 11g新特性:spfile Fault-tolerant增强 | Blog首页 | 《循序渐进Oracle》上架销售 »

Oracle 11g SQL*Plus欢迎信息的变化

使用Oracle 11g的SQL*Plus,发现欢迎信息发生了变化,现在的欢迎信息是:

[oracle@test126 ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Aug 24 15:15:31 2007

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning and Real Application Testing options

这里的Real Application Testing 是Oracle 11g的一大新特性。

在Oracle10g中,这里的Options是Data Mining:

$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Aug 24 15:25:43 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning and Data Mining options

而一个安装的Oracle9iR2中的显示如下:

[oracle@dell2650 oracle]$ sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.8.0 - Production on Fri Aug 24 10:17:40 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning option
JServer Release 9.2.0.8.0 - Production

一个小的变化,显示了Oracle对这一特性的重视和突出。

SQL> select * from v$option where parameter like '%Testing%';

PARAMETER VALUE
-------------------------------------------------- ----------
Real Application Testing TRUE

Oracle Real Application Testing 缩写位RAT,RAT是Oracle企业版中一个独立的收费组件,其收费价格为:
* Oracle Real Application Testing -- $10,000 per processor or $200 per named user;

这是Oracle Database 11g中新增的四个收费组件之一,其余三个为:
* Oracle Advanced Compression -- $10,000 per processor or $200 per named user;
* Oracle Total Recall -- $5,000 per processor or $100 per named user; and,
* Oracle Active Data Guard -- $5,000 per processor or $100 per named user.

RAT被成为真正的应用测试,能够完全重现生产环境中的负载和应用负荷,从而能够更精确的知道升级、硬件更换或者系统变更,以前对于不同的版本升级,我们通常很难完全重现或模拟生产环境的负荷。
RAT包含两个组件,这两个组件是:
1.Database Replay - 用于捕获产品环境的负载并且在测试环境中应用。
2.SQL Performance Analyzer - 识别SQL执行计划,发现性能变化并提供分析数据与优化建议等。

-The End-


历史上的今天...
    >> 2009-08-24文章:
    >> 2005-08-24文章:
           又将是一个不眠的夜晚

无觅

By eygle on 2007-08-24 16:21 | Comments (0) | Oracle12c/11g | 1571 |


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com