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

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

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

查看本文来源