【正文】 關(guān)。對抓出來的語句進(jìn)行分析，如果懷疑是統(tǒng)計(jì)信息不正確引起的全表掃瞄，可以先進(jìn)行統(tǒng)計(jì)信息的收集，方法如下。 基于Schema的統(tǒng)計(jì)信息收集begin (ownname = 39。, cascade = true, degree = 7)。 關(guān)于DRM216。在操作系統(tǒng)層面，節(jié)點(diǎn)1的cpu利用率為0，節(jié)點(diǎn)2的cpu利用率為20。216。再者，從Oracle的trace文件里可以看出在兩次交易故障發(fā)生時(shí)，oracle rac的DRM 正在做大量的數(shù)據(jù)同步信息。2． 修改備份出來的數(shù)據(jù)庫參數(shù)文件，在文件末尾添加*._gc_affinity_time=0*._gc_undo_affinity=false3． shutdown 當(dāng)前數(shù)據(jù)庫，已剛才備份修改后的數(shù)據(jù)庫參數(shù)文件啟動到nomountSQL Shutdown immediate (兩臺機(jī))SQL Startup pfile=’/home/oracle/’ nomount。kjfcrfg: DRM window size = 04096 (min lognb = 15) *** 20070519 15:28:Reconfiguration started (old inc 0, new inc 16)Synchronization timeout interval: 900 secList of nodes: 0 1*** 20070519 15:28: Global Resource Directory frozennode 0release 10 2 0 2node 1release 10 2 0 2 number of mastership buckets = 128 domain attach called for domid 0 * kjbdomalc: domain 0 invalid = TRUE * kjbdomatt: first attach for domain 0 asby init, 0/0/x1 asby returns, 0/0/x1/false * Domain maps before reconfiguration: * DOMAIN 0 (valid 0): 0 * End of domain mappings * Domain maps after reputation: * DOMAIN 0 (valid 0): 0 1 * End of domain mappings Dead inst Join inst 0 1 Exist inst Active Sendback Threshold = 50 % Communication channels reestablished sent syncr inc 16 lvl 1 to 0 (16,5/0/0) sent synca inc 16 lvl 1 (16,5/0/0) received all domreplay () sent master 1 () sent syncr inc 16 lvl 2 to 0 (16,7/0/0) sent synca inc 16 lvl 2 (16,7/0/0) Master broadcasted resource hash value bitmaps* kjfcrfg: domain 0 valid, valid_ver = 16 Nonlocal Process blocks cleaned out Set master node info sent syncr inc 16 lvl 3 to 0 (16,13/0/0) sent synca inc 16 lvl 3 (16,13/0/0) Submitted all remoteenqueue requestskjfcrfg: Number of mesgs sent to node 1 = 0 sent syncr inc 16 lvl 4 to 0 (16,15/0/0) sent synca inc 16 lvl 4 (16,15/0/0) Dwncvts replayed, VALBLKs dubious sent syncr inc 16 lvl 5 to 0 (16,18/0/0) sent synca inc 16 lvl 5 (16,18/0/0) All grantable enqueues granted sent syncr inc 16 lvl 6 to 0 (16,20/0/0) sent synca inc 16 lvl 6 (16,20/0/0) *** 20070519 15:28: Submitted all GCS cache requests sent syncr inc 16 lvl 7 to 0 (16,22/0/0) sent synca inc 16 lvl 7 (16,22/0/0) Post SMON to start 1st pass IR Fix write in gcs resources sent syncr inc 16 lvl 8 to 0 (16,24/0/0) sent synca inc 16 lvl 8 (16,24/0/0) *** 20070519 15:28:Reconfiguration plete* domain 0 valid?: 1 *** 20070519 15:28:kjxgrtmc2: mounting member 0 thread 1Begin DRM(32) sent syncr inc 16 lvl 9 to 0 (16,0/31/0) sent synca inc 16 lvl 9 (16,0/31/0) ... sent syncr inc 16 lvl 39 to 0 (16,0/36/0) sent synca inc 16 lvl 39 (16,0/36/0) *** 20070519 15:28: sent syncr inc 16 lvl 40 to 0 (16,0/38/0) sent synca inc 16 lvl 40 (16,0/38/0) End DRM(32) 日志文件太小引起的切換過于頻繁假設(shè)現(xiàn)有三個(gè)日志組，每個(gè)組內(nèi)有一個(gè)成員，每個(gè)成員的大小為512MB，現(xiàn)在想把此三個(gè)日志組的成員大小都改為1G。/oracle/oradata/39。) size 1024M。switchswitchdatabase1。logfiledatabase3。database1sizeadd(39。1024M。logfile/oracle/oradata/39。 216。logfile。logfile。logfile。drop altergroup 備份當(dāng)前的最新的控制文件 SQLdatabasetrace若是用9207 版本的SQLPLUS，則會出現(xiàn)：沒反應(yīng)，HANG住。檢查是否真因?yàn)榇薆UG造成此現(xiàn)象：$ ps ef | grep tnslsnrora10g 8909 1 0 Sep 15 ? 902:44 /u05/10GHOME/DBHOME/bin/tnslsnr sales inheritora10g 22685 8909 0 14:19:23 ? 0:00 /u05/10GHOME/DBHOME/bin/tnslsnr sales inherit正常情況只有一個(gè)監(jiān)聽器，而此BUG則會出現(xiàn)兩個(gè)監(jiān)聽器。則語句就是：SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF 查詢委托返回記錄不對216。 原因：未知，懷疑為Oracle Bug216。 其它這個(gè)問題已經(jīng)多次出現(xiàn)，與很多Oracle 售前人員交流過，沒有定論。Aggregation EnabledAny query that displays HASH GROUP BY in the execution plan could hit this bug.The HASH GROUP BY feature is enabled by default in .l SolutionPatch 4604970 can be downloaded from Metalink for most platforms .Problem is resolved in latest Patchset release .Workaround:Increase the memory used by hash group byOrDisable the use of hash group by eg: set optimizer_features_enable to orset _gby_hash_aggregation_enabled to FALSE. Linux + Oracle 10g RAC的平臺上，發(fā)生節(jié)點(diǎn)重啟故障216。l Mon Jun 11 16:54:38 2007Error: unexpected error (6) from the Cluster Service (LCK0)Mon Jun 11 16:54:38 2007Errors in file /u01/app/oracle/admin/rac/bdump/:ORA29702: error occurred in Cluster Group Service operationMon Jun 11 16:54:38 2007Errors in file /u01/app/oracle/admin/rac/bdump/:ORA29702: error occurred in Cluster Group Service operationMon Jun 11 16:54:38 2007Errors in file /u01/app/oracle/admin/rac/bdump/:ORA29702: error occurred in Cluster Group Service operationMon Jun 11 16:54:38 2007Errors in file /u01/app/oracle/admin/rac/bdump/:ORA29702: error occurred in Cluster Group Service operationMon Jun 11 16:54:38 2007Errors in file /u01/app/oracle/admin/rac/bdump/:ORA29702: error occurred in Cluster Group Service operationMon Jun 11 16:54:38 2007System state dump is made for local instanceMon Jun 11 16:54:38 2007Errors in file /u01/app/oracle/admin/rac/bdump/:ORA29702: error occurred in Cluster Group Service operationMon Jun 11 16:54:38 2007Errors in file /u01/app/oracle/admin/rac/bdump/:ORA29702: error occurred in Cluster Group Service operationMon Jun 11 16:54:38 2007Errors in file /u01/app/oracle/admin/rac/bdump/:ORA29702: error occurred in Cluster Group Service operationMon Jun 11 16:54:38 2007Errors in file /u01/app/oracle/admin/rac/bdump/:ORA29702: error occurred in Cluster Group Service operationMon Jun 11 16:54:38 2007Errors in file /u01/app/oracle/admin/rac/bdump/:ORA29702: error occurred in Cluster Group Service ope。 現(xiàn)象：其中某一結(jié)點(diǎn)操作系統(tǒng)重啟。具體內(nèi)容參見metalink：Wrong Results Possible on When New HASH GROUP BY Feature is Used（Doc ID: Note:）l CauseBug 4604970 Wrong Results With 39。如問題仍然存在，使用下面語句：SQL Analyze table pute statistics for all indexes。 現(xiàn)象：查詢語句結(jié)果集返回不全，只返回一條或其中幾條。 解決方法：打補(bǔ)丁4518443 文件里加入：SUBSCRIBE_FOR_NODE_DOWN_EVENT_listener_name=OFF其中，listener