ITPub博客

"Checked for relevance on 07-Feb-2007, archived"PURPOSE-------To enable asynchronous I/O for Oracle9iR2 on Red Hat Linux Advanced Server2.1, please execute the following steps:1) cd to $ORACLE_HOME/rdbms/lib a) make -f ins_rdbms.mk async_on b) make -f ins_rdbms.mk ioracle2) Parame...

在测试数据库的awr报告中发现大量的 dfs lock handle，引出这个文档作为参考25个并发，每个并发持续执行一个并行度为24的查询sql，在等待事件中 列出了等待时间最长的dfs lock handleAPPLIES TO:Oracle Database - Enterprise Edition - Version 11.1.0.6 to 12.1.0.2B1 [Release 11.1 to 12.1]Information in this...

APPLIES TO:Oracle Database - Enterprise Edition - Version 9.2.0.1 and laterInformation in this document applies to any platform.GOALYou want to know why the parallel execution of your SQL statement is using a high value for degree of parallelism (DOP). SOLUTIONFactors that ...

APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterInformation in this document applies to any platform.SYMPTOMSAfter upgrade to 11.2.0.3, we see wait event resmgr:pq queued permanently.CAUSE Not enough parallel slaves available.SOLUTIONIncre...

DescriptionIt shows the parallel degree limit from resource manager for all connect users.Degrees of 0 or 1 mean that the query is running in serial.Example output SID SERIAL# USERNAME PLAN RESOURCE_CONSUMER_GROUP PARALLEL_DEGREE_LIMIT_P1 --- -----...

安装问题2：ASM单个磁盘不能操作2T bootinfo –s hdisk8 移除已经创建好的数据库，删除asm卷组及磁盘： p7402:/home/oracle$export ORACLE_SID=+ASM2 p7402:/home/oracle$sqlplus / as sysdba SQL> select instance_name from v$instance; INSTANCE_NAME -------------------------------- +ASM2 SQL> s...

Oracle Linux 6.2上安装oracle 11g2$./runInstaller -ignoreSysPrereqs 安装刚开始,马上报一个SEVERE: [FATAL] oracle6: oracle6的错误，点确定后就退出安装了。[@more@]错误日志如下：INFO: Loading beans from Xml Bean Store. [BeanStoreName:config-data]INFO: Setting value for the property:id in the bean:configcmd……INFO: Setting value for the property:platformcmdmap in the bean:configcmdINFO: Setting value for the property:configcmds in the bean:configcmdmappingsSEVERE: [FATAL] oracle6: oracle6 经检查，host

In this DocumentPurposeScopeDetails What is parallelism best used for? When and when not to Implement Parallel Execution...

DescriptionIt shows the parallel degree limit from resource manager for all connect users.Degrees of 0 or 1 mean that the query is running in serial.Example output SID SERIAL# USERNAME PLAN RESOURCE_CONSUMER_GROUP PARALLEL_DEGREE_LIMIT_P1 --- -----...

背景是在某项目进行POC测试的时候，将数据加载和翻倍之后，客户提供了一个大查询SQL，涉及署数据量2T左右，客户的SQL不允许修改、建立索引等调优，只能直接跑在三节点组成的RAC集群上，我们私下加上hint 开启64并发，跑出来的结果是10分钟左右；不加hint，不进行IO校准，同样的SQL跑了1个半小时，而且负载只在一个节点上...

关于IO校准的操作在自动并行查询/DML等情况下很有必要对数据库进行实际检查和校验。APPLIES TO:Enterprise Manager for Oracle Database - Version 11.1.0.6 and laterOracle Database - Enterprise Edition - Version 11.1.0.6 and laterInformation in this document applies to any platform.***Checked for rel...

Automatic degree of parallelism is disabled: IO calibrate statistics are missing

APPLIES TO:Oracle Database - Personal Edition - Version 8.1.5.0 and laterOracle Database - Enterprise Edition - Version 8.1.5.0 and laterInformation in this document applies to any platform.PURPOSEThe document gives a beginner's overview of parallel execution. It does not cover everyth...

配置EM具体步骤一、配置EM dbconsole的步骤信息emca -config dbcontrol db -repos recreateEMCA 开始于 2007-10-12 11:16:40EM Configuration Assistant 10.2.0.1.0 正式版版权所有 (c) 2003, 2005, Oracle。保留所...

近期一次的存储异常断电导致了在双节点的RAC环境中，一个节点出现了ORA-12537: TNS: connection closed 错误。 环境：Oracle Linux 5.5 + oracle 11g + ASM 网上搜了一下也解决不了问题，最终在一个高手的协助下进行了故障排除，在此进行了记录。[@more@][grid@racdb1 bin]$ exit logout -bash-3.2$ cd $ORACLE_HOME/bin -bash-3.2$ ls -l oracle -rwxrwsrwx 1 oracle asmadmin 232399431 10-25 11:14 oracle -bash-3.2$ chmod 6751 oracle -bash-3.2$ ls -l oracle -rwsr-x--x 1 oracle asmadmin

环境：oracle linux5.5   + oracle 11g  rac 问题描述：客户端无法连接数据库，并报错：ORA-12537: TNS:connection closedlsnrctl status 监听正常，lsnrclt stop/start 能正常启动，尝试连接，依然...

在任何系统优化过程中，“80/20原则”是我们一定要关注的问题。简单的说，就是我们系统80%的性能问题、现象，都是有少数几个甚至一个问题造成的。这就需要我们面对复杂的系统性能问题的时候，要学会“拨开云雾、蛇打...

设置环境变量NLS_lANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBKTNS_ADMIN=F:\MyJob\Oracle11gInstantClient\ADMINPath=F:\MyJob\Oracle11gInstantClient;其中ADMIN文件夹需手工创建，用来存放tnsnames.ora，或者不创建将tnsnames.ora放在客户端根目录下，效果一样tnsnames.ora内容可参考：ORCL= ...

平台：oel linux 错误现象：安装11g rac r2 rac 时，运行 ./runInstall，在选择网卡类型的下一步时，报  INS 41112,查看detail信息，发现提示/tmp目录下没有写权限。（可能是以前曾经安装过RAC时的遗...

ORACLE10g推出了ASM(Automatic Storage Management --自动存储管理)特性，该特性拥有易管理，高自动性，并且，拥有号称超越裸设备IO性能。这个特性实际上就是oracle回收了数据库依赖的第三方文件系统的功能，与oracle一贯的习惯是一致的。在oracle10gr2中又推出了ASMCMD增强对ASM的管理。升级到11gR2版本后，又被正名为传说...