-
编辑 删除
DFS lock handle
DFS lock handle is a kind of wait event for dynamic lock manager(DLM) syncronzication wait A DFS lock handle wait in RAC is generally associated with a Cross Instance (CI) call, requesting some other instance to perform some work on behalf of this process.To Understand what is going wrong with this, we need understand what is the kind of calls made and how the call is propagated to other and where it is stuck these information can be found only from systemstate dump[@more@]
-
编辑 删除
细节决定一切-多工控制文件有感
1.首先查看控制文件情况SQL> show parameter controlNAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_file_record_keep_time integer 7 control_files string E:ORACLEPRODUCT10.2.0ORADATAORCLCONTRO L03.CTL 2.shutdown immediate关闭数据库,并且在相同目录下增加控制文件2, CONTROL02.CTL,同时修改pfile内容如下:*.control_files='E:oracleproduct10.2.0oradataorclCONTROL01.CTL,E:oracleproduct10.2.0oradataorclCONTROL02.CTL,E:oracleproduct10.2.0oradataorclCONTR
-
编辑 删除
gc cr request 'gcs log flush sync'
This is how it happens -1)You fired an update statement on Instance-2. 2)However, the request for desired blocks was gone to Instance-1. So Instance-2 was waiting on ''gc cr request'. 3)Instance-1 had the requested blocks but before it ships the blocks to Instance-2, it need to flush the changes from current block to redo logs on disks. Until this is done Instance-2 waits on event - 'gcs log flush sync'.The cause of this wait event 'gcs log flush sync' is mainly - Redo log IO performance.To avoi
-
编辑 删除
EXP-00091
exp scott/tiger file=test.dmp tables=emp query="where empno <7499"一般情况下，是由于字符集设置问题，这个case下不存在字符集的问题，去掉query后，exp成功。metalink上的解释 The precalculated optimizer statistics are flagged as questionable at export time if:1. There are row errors while exporting2. The client character set or NCHAR character set does not match the server character set orNCHAR character set3. A QUERY clause is specified4. Only certain partitions or subpartitions are expo
-
编辑 删除
10g RAC安装成功
哎呀妈呀，这玩意儿咋这么难整啊，总共发起了2次猛烈的冲锋，每次都耗时N天，终于在第二次冲锋中将其拿下。不容易啊，怎么得给俺搬个奖吧。发表下获奖感言：感谢MTV，感谢CCTV，感谢铁岭TV，感谢。。。TV，哎呀妈呀，感谢的人太多了，最重要的是感谢老熊，没有你的帮助，俺也攻克不了这么多难题啊，谢谢老熊。中间遇到了N多问题，饱受折磨啊，特别是装CRS的时候，重装了不下10遍。这下可好了，CRS装的倍儿熟了。说了这么多鸟语，最后总结就一句话：耐心，耐心，再耐心一些。[@more@]
