ITPub博客

转：http://blog.itpub.net/17203031/viewspace-1063523/Oracle数据库发展到今天，“IO为王”已经是一种发展方向趋势。ExtraData一体机的重要特色之一就是最大程度的发挥IO能力、提高IO吞吐量。 相比CPU和内存，IO存储有其特殊性。我们讨论IO，通常成为I/O栈（I/O Stack）。I/O栈设计的对象是一系列关键组件层，包括...

在Oracle11gR2中回收dba权限，会一并把通过”quota“分配的表空间限额也回收了。原先一直只知道回收dba权限时会一并回收unlimited tablespace权限看实验：10:03:30 emoss开发库>select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Data...

Oracle 11g R2 Clusterware新特性 – HAIP详解 前段时间在聊RAC私网(Private Network)冗余技术的时候，朋友们大多搬出Bonding技术，当时我说了个HAIP，但朋友中几乎没有对它了解的。当时，我简单介绍了下HAIP特性，今天则更细一点去了解。HAIP全称为Highly Available Virtual IP，是...

Disable the automatic startup of the Oracle Clusterware (CRS|HAS) softwareSometimes, you need for maintenace reasons or others to disable the automatic startup of the Oracle Clusterware software. For that, we use the following commands1...

We can say that not has the same result.crsctl start/stop crs - Manage start/stop the entire Oracle Clusterware stack on a node, including the OHASD process, this command is to be used only on the local node..crsctl start/stop cluster - Manage start/stop the Oracle Clusterware stack on loc...

Oracle 11g introduced automatic DOP 。ODM KNOWLEDGE:When automatic degree of parallelism (Auto DOP) is on the Oracle Optimizer will Automatically decide the DOP for a statement based on the resource requirements of the statement. Any statement that can be parallelized is a candidate for AUTO ...

Voting Disk and OCR in 11gR2

转：http://www.oracle-base.com/articles/11g/append-values-hint-11gr2.phpAPPEND_VALUES Hint in Oracle Database 11g Release 2We have been able take advantage of the performance benefits of direc...

启用表级的Result CacheResult Cache是Oracle11g引入的新特性。在Oracle11g Release 1,我们可以通过如下方式启用result cache1) 数据库级启用   alter system set result_cache_mode = force;&nbs...

Using Oracle Database 11g Release 2 Result Cache in an Oracle RAC Environment (转：http://www.oracle.com/technetwork/articles/datawarehouse/vallath-resultcache-rac-284280.html)By Murali Vallat...

query result cache in oracle 11gCaching has been a feature of Oracle for as long as most of us can remember. Over the many years and versions, Oracle has continually expanded its caching mecha...

Automatic SQL Tuning in Oracle Database 11g Release 1As part of Automatic SQL Tuning, Oracle 11g automatically runs the SQL Tuning Advisor against high impact SQL statements duri...

ORACLE 11G 自动维护任务： 自动维护任务是一种按规则自动启动的数据库维护操作任务。比如自动收集为查询优化器使用的统计信息。自动维护任务按维护窗口自动运行。所谓自动维护窗口是按照预定义的...

Oracle11gRAC跨节点并行查询的控制，跟先前的版本有所变化：参数instance_groups被废弃，并新增加了参数：PARALLEL_FORCE_LOCAL来限制内部节点的并行操作．使用Services来确定并行查询将在哪些节点...

刚在Oracle Linux 6环境下搭建了一套11gR2 RAC数据库集群，客户端(Oracle 10g)通过SCAN IP访问数据库时遇到下述错误：  SQL> conn sys/sys@studydb as sysdba  ERROR:  O...