CBA

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

2020-01-16 15:14:44来源:励志吧0次阅读

使用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执行计划,发现性能变化并提供分析数据与优化建议等。

查看本文来源

什么草药舒筋活络
小男孩风热感冒咳嗽的症状
动脉粥样硬化能吃通心络胶囊吗
用法用量明确精准的止咳药有哪种
分享到: