一套AIX上的4节点10.2.0.4 RAC系统在1月份出现实例hang住的现象，并伴随有ORA-00600:[qctcte1]内部错误，trace文件内容如下:
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
siposrc1_ora_102944.trc
Oracle  Database  10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With  the Partitioning,  Real  Application Clusters, OLAP, Data Mining
and  Real  Application Testing options
ORACLE_HOME = /oracle/product/10.2.0/db_1
System  name : AIX
Node  name : jszydb1
Release: 3
Version: 5
Machine: 00CE31834C00
Instance  name : siposrc1
Redo thread mounted  by  this instance: 1
Oracle process number: 34
Unix process pid: 102944, image: oracle@jszydb1
 
***  ACTION  NAME :() 2010-01-18 15:53:11.530
*** MODULE  NAME :(JDBC Thin Client) 2010-01-18 15:53:11.530
*** SERVICE  NAME :(siposrc) 2010-01-18 15:53:11.530
*** SESSION ID:(2175.6953) 2010-01-18 15:53:11.530
*** 2010-01-18 15:53:11.530
ksedmp: internal  or  fatal error
ORA-00600: 内部错误代码, 参数: [qctcte1], [0], [], [], [], [], [], []
Current  SQL statement  for  this session:
SELECT  /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param( 'parallel_execution_enabled' ,  'false' ) NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL( SUM (C1),: "SYS_B_00000" ), NVL( SUM (C2),: "SYS_B_00001" )  FROM  ( SELECT  /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL( "SIPO_ECLA$_TEMP" )  FULL ( "SIPO_ECLA$_TEMP" ) NO_PARALLEL_INDEX( "SIPO_ECLA$_TEMP" ) */ : "SYS_B_00002"  AS  C1,  CASE  WHEN  "SIPO_ECLA$_TEMP" . "SEQ_ID" =: "SYS_B_00003"  OR  "SIPO_ECLA$_TEMP" . "SEQ_ID" =: "SYS_B_00004"  OR  "SIPO_ECLA$_TEMP" . "SEQ_ID" =: "SYS_B_00005"  OR  "SIPO_ECLA$_TEMP" . "SEQ_ID" =: "SYS_B_00006"  OR  "SIPO_ECLA$_TEMP" . "SEQ_ID" =: "SYS_B_00007"  OR  "SIPO_ECLA$_TEMP" . "SEQ_ID" =: "SYS_B_00008"  OR  "SIPO_ECLA$_TEMP" . "SEQ_ID" =: "SYS_B_00009"  OR  "SIPO_ECLA$_TEMP" . "SEQ_ID" =: "SYS_B_00010"  OR  "SIPO_ECLA$_TEMP" . "SEQ_ID" =: "SYS_B_00011"  OR  "SIPO_ECLA$_TEMP" . "SEQ_ID" =: "SYS_B_00012"  OR  "SIPO_ECLA$_TEMP" . "SEQ_ID" =: "SYS_B_00013"  OR  "SIPO_ECLA$_TEMP" . "SEQ_ID" =: "SYS_B_00014"  OR  "SIPO_ECLA$_TEMP" . "SEQ_ID" =: "SYS_B_00015"  OR  "SIPO_ECLA$_TEMP" . "SEQ_ID" =: "SYS_B_00016"  OR  "SIPO_ECLA$_TEMP" . "SEQ_ID" =: "SYS_B_00017"  OR  "SIPO_ECLA$_TEMP" . "SEQ_ID" =: "SYS_B_00018"  OR  "SIPO_ECLA
.
 
.
$_TEMP" . "SEQ_ID" =: "SYS_B_40000"  OR  "SIPO_ECLA$_TEMP" . "SEQ_ID" =: "SYS_B_40001"  OR  "SIPO_ECLA$_TEMP" . "SEQ_ID" =: "SYS_B_40002"  THEN  : "SYS_B_40003"  ELSE  : "SYS_B_40004"  END  AS  C2  FROM  "SIPO_ECLA$_TEMP"  SAMPLE BLOCK (: "SYS_B_40005"  , : "SYS_B_40006" ) SEED (: "SYS_B_40007" ) "SIPO_ECLA$_TEM
 
STACK
qctcte qctocssm qctcopn qctcopn xtyxcssr xtyopncb qctcopn qctcpqb <- qctcpqbl <- xtydrv <- opitca <- kksFullTypeCheck <- rpiswu2 <- kksSetBindType <- kksfbc <- opiexe <- opiall0 <- opikpr <- opiodr <- rpidrus <- skgmstack <- rpidru <- rpiswu2 <- kprball <- IPRA <- IPRA <- kkedsSel <- kkecdn <- kkotap <- kkoiqb <- kkooqb <- kkoqbc <- apakkoqb <- apaqbdDescendents <- 3d4 <- apaqbdListReverse <- 06c <- apaqbd <- apadrv <- opitca <- kksLoadChild <- kxsGetRuntimeLock <- 810 <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0 <- opiall0 <- opial7 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv
提交SR，MOS认为可能是Bug 6666870，给出以下方案: There are a large number of possible bugs but Bug 6666870 is the most likely culprit. There is no one off patch available. 10205 is not yet available.
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
ACTION  PLAN:
=============
1.Please disable Cost Based Transformation  as  a workaround, this can be done  in  the init.ora/spfile  or  at  the session  level ,  for  example:
SQL>  alter  session  set  "_optimizer_cost_based_transformation" = off  ;
 
2.Apply the 10205 patch  set  when  it becomes available.
 
3.If the optimiser change fails  to  resolve your issue, please advise us  of  any  recent changes  to  your DB  or  server?
 
4. In  particular, did you recently apply the CPUJAN2008 Patch?
If so, please see Note.558901.1 Ext/Mod ORA-00600 internal error code, arguments [qctcte1]  After  Applying CPUJAN2008 Patch
 
5.If there  is  a  function  based  index  involved, please see;
Note.788124.1 Ext/Pub ORA-00600 [qctcte1]  With  Function  Based  Index  Access
 
6.Changing your code  to  eliminate the parallel clauses may also act  as  a workaround.