ORA-00600[kqlInvObj:user]處理
今天現場的兄弟打電話來說，在開發庫上（win7 64bit）剛安裝11.2.0.1.0後,先是用數據泵導數據有問題，好不容易解決，接著執行SQL報錯，簡單的SQL不報錯，只要幾張表關聯的就會報錯，於是把現場的日志拿回來分享。對於這種ORA-00600的錯誤，都是oracle的bug，只有求助於metalink。
*** 2014-11-25 11:14:06.444
ORA-00600: 內部錯誤代碼, 參數: [kqlInvObj:user], [90], [], [], [], [], [], [], [], [], [], []
ORA-00600: 內部錯誤代碼, 參數: [kqlInvObj:user], [90], [], [], [], [], [], [], [], [], [], []
CREATE GLOBAL TEMPORARY TABLE "SYS"."SYS_TEMP_0FD9D6606_37915C" ("C0" DATE,"C1" VARCHAR2(20),"C2" VARCHAR2(50),"C3" NUMBER(15,3),"C4" NUMBER(15,3),"C5" NUMBER,"C6" NUMBER ) IN_MEMORY_METADATA CURSOR_SPECIFIC_SEGMENT STORAGE (OBJNO 4254950918 ) CACHE
----- Current SQL Statement for this session (sql_id=86bx9jarmy2hq) -----
SELECT DISTINCT DR.NAME REGION_NAME,
D.ENERGY_ID,
M.INSTALL_POINT_NO ANLAGE,
LTRIM(U.VKONT, '0') AS VKONT,
U.CNAME,
NVL(M.CT_RATIO, 1) CT_RATIO,
NVL(M.PT_RATIO, 1) AS PT_RATIO,
M.HANGCARDNO,
T.CAPACITY,
D.ASSET_NO,
D.METER_ID,
TO_CHAR(D.DT, 'YYYY-MM-DD') AS TIME,
D.ACTIVE_TOTAL,
D.TOTAL_START_CODE,
D.TOTAL_END_CODE,
TO_CHAR(D.START_CODE_TIME, 'YYYY-MM-DD HH24:MI:SS') AS START_CODE_TIME,
TO_CHAR(D.END_CODE_TIME, 'YYYY-MM-DD HH24:MI:SS') AS END_CODE_TIME,
D.LINE_ID,
D.LINE_NAME,
DFR.In_Energy,
DFR.Out_Energy,
DFR.Loss_Energy,
DFR.Loss_Rate,
NVL(DECODE(TER.TERM_ASSET_NO,
NULL,
TRIM(M.METER_ID),
TER.METER_ID),
'7783') AS METERCODE
FROM DTL_LL_MTERGY_DAY D,
DTL_LL_FD_RATE_DAY DFR,
MD_CCSMETERS M,
MD_INSTALL_POINT P,
MD_CONTRACT C,
MD_USER U,
MD_TERMINAL TER,
MD_TRANSFORMER T,
SA_LL_EXP_METER_DAY EMD,
DIM_REGION DR
WHERE D.Line_Id = DFR.Line_Id
AND DFR.DT(+) = D.DT
AND DFR.REGION = DR.CODE
AND (M.BUREAU_NO = D.ASSET_NO OR M.BUREAU_NO = LPAD(D.ASSET_NO, 18, '0'))
AND P.INSTALL_POINT_NO(+) = M.INSTALL_POINT_NO
AND P.INSTALL_POINT_NO = C.INSTALL_POINT_NO(+)
AND C.VKONT = U.VKONT(+)
AND T.HANGCARDNO(+) = M.HANGCARDNO
AND M.TERMINAL_BUREAU_NO = TER.TERM_ASSET_NO(+)
AND EMD.ENERGY_ID = D.ENERGY_ID
AND EMD.DT = D.DT
AND D.DT BETWEEN TO_DATE('2013-7-8', 'YYYY-MM-DD') AND TO_DATE('2013-8-6', 'YYYY-MM-DD');
在matelink查詢，顯示有幾個bug匹配。
