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

作者：盖国强 来源:eygle.com

使用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 -- ,000 per processor or 0 per named user;

这是Oracle Database 11g中新增的之一，其余三个为:
* Oracle Advanced Compression -- ,000 per processor or 0 per named user;
* Oracle Total Recall -- ,000 per processor or 0 per named user; and,
* Oracle Active Data Guard -- ,000 per processor or 0 per named user.

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