*** SERVICE NAME:(orcl) 2007-05-22 07:54:34.484
*** SESSION ID:(123.2058) 2007-05-22 07:54:34.484
*** 2007-05-22 07:54:34.484
ksedmp: internal or fatal error
ORA-00600: 内部错误代码, 参数: [19004], [], [], [], [], [], [], []
Current SQL statement for this session:
SELECT jzmx.zlxmid , NVL(jzmx.price,0) AS Price , NVL(jzmx.quantity,0) AS quantity , NVL(ZLXM.isControlPrice,' ') AS IsControlPrice , NVL((CASE WHEN ZLXM.isControlPrice='Y' THEN CASE WHEN jzmx.price>(CASE WHEN NVL(jzmx.maxprice,0)=0 THEN (CASE WHEN xmPrice.price IS NULL THEN zlxm.maxPrice ELSE xmPrice.price END ) ELSE jzmx.maxprice END ) THEN (CASE WHEN NVL(jzmx.maxprice,0)=0 THEN (CASE WHEN xmPrice.price IS NULL THEN zlxm.maxPrice ELSE xmPrice.price END ) ELSE jzmx.maxprice END ) ELSE jzmx.price END Else jzmx.price END),0) AS BxPrice , NVL((CASE WHEN jzmx.BXBL IS NULL THEN bxbz.BXBL ELSE jzmx.BXBL END),0) AS BXBL , (CASE WHEN zlxm.ZJXMTYPE='ZJXM_TYPE_ZL' THEN (CASE WHEN xmsq.xmid IS NOT NULL THEN 1000000000 ELSE 1000000000 END) ELSE 1000000000 END) AS CEPrice , NVL(CFSQ.Auditing,' ') AS IsXMAutited , (CASE WHEN zlxm.ZJXMTYPE='ZJXM_TYPE_ZL' THEN (CASE WHEN xmsq.xmid IS NOT NULL THEN .8 ELSE .8 END) ELSE .8 END) AS CEBXBL , (CASE WHEN XMSQ_TJXM.xmid IS NULL THEN 0 ELSE 1 END ) AS IsTJXM , (CASE WHEN XMSQ_LCYX.xmid IS NULL THEN 0 ELSE 1 END ) AS IsLCYX , (CASE WHEN XMSQ_GZYP.xmid IS NULL THEN 0 ELSE 1 END ) AS IsGZYP , (CASE WHEN XMSQ_DBZXJ.xmid IS NULL THEN 0 ELSE 1 END ) AS IsBBHZDBZXJNDXM , (CASE WHEN NOT ZY.xmid IS NULL THEN 1 ELSE 0 END) AS IsZY , CFSQ.QuantityAudited , zlxm.ZJXMTYPE , (CASE WHEN bxbz.description='乙类' THEN 1 ELSE 0 END ) AS IsYL FROM JZMXINFOR jzmx INNER JOIN zlxminfor zlxm ON jzmx.zlxmid=zlxm.xmid
LEFT JOIN ypzlbxzlbz bxbz ON zlxm.bxzlid=bxbz.bxzlid
LEFT JOIN ZLXMDJPRICE xmPrice ON (zlxm.ZJXMTYPE='ZJXM_TYPE_ZL' AND xmPrice.YLJGDJID='YLJGl_LEVEL_3' AND xmPrice.xmid=jzmx.zlxmid )
LEFT JOIN (select JZDJLSH,xmid ,Auditing,NVL(sum (QuantityAudited),0) as QuantityAudited from JZMXXMSQB where JZDJLSH='1000686593' AND Auditing='TSXMSHZT_AUDITING'group by JZDJLSH,xmid ,Auditing ) CFSQ ON (JZMX.JZDJLSH=CFSQ.JZDJLSH AND jzmx.ZLXMID=CFSQ.XMID)
LEFT JOIN ZLXMSQINFOR XMSQ ON (zlxm.xmid=xmsq.xmid AND xmsq.SQTYPE='JZXMSQSH_WKSS')
LEFT JOIN ZLXMSQINFOR XMSQ_TJXM ON (zlxm.xmid=XMSQ_TJXM.xmid AND XMSQ_TJXM.SQTYPE='JZXMSQSH_TJXM')
LEFT JOIN ZLXMSQINFOR XMSQ_LCYX ON (zlxm.xmid=XMSQ_LCYX.xmid AND XMSQ_LCYX.SQTYPE='JZXMSQSH_LCYX')
LEFT JOIN ZLXMSQINFOR XMSQ_GZYP ON (zlxm.xmid=XMSQ_GZYP.xmid AND XMSQ_GZYP.SQTYPE='JZXMSQSH_GZYP')
LEFT JOIN ZLXMSQINFOR XMSQ_DBZXJ ON (zlxm.xmid=XMSQ_DBZXJ.xmid AND XMSQ_DBZXJ.SQTYPE='JZXMSQSH_BBHZDBZXJNDXM')
LEFT JOIN ZLXMSQINFOR ZY ON (zlxm.xmid=ZY.xmid AND ZY.SQTYPE='JZXMSQSH_ZY')
WHERE jzmx.DISUSE='N' AND jzmx.JZDJLSH='1000686593'
AND (to_date('2006-1-1','yyyy-mm-dd hh24:mi:ss')<=cfDate AND cfDate<to_date('2007-1-1','yyyy-mm-dd hh24:mi:ss'))
ORDER BY jzmx.zlxmid ,jzmx.quantity ,jzmx.cfdate
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
Repeat 51 times
1818E4D0 06012C00 584C5A0C 59545F4D 315F4550 [.,...ZLXM_TYPE_1]
1818E4E0 4C5A0933 555F4D58 0254494E C1023331 [3.ZLXM_UNIT.13..]
1818E4F0 D032050E 01B1CAA1 06012C80 584C5A0D [..2......,...ZLX]
1818E500 59545F4D 315F4550 5A093033 5F4D584C [M_TYPE_130.ZLXM_]
1818E510 54494E55 30333103 1F02C203 D5BFC306 [UNIT.130........]
1818E520 01ACC6C5 06012C80 584C5A0D 59545F4D [.....,...ZLXM_TY]
1818E530 315F4550 5A093133 5F4D584C 54494E55 [PE_131.ZLXM_UNIT]
1818E540 31333103 2002C203 D5BFC304 2C8001C6 [.131... .......,]
1818E550 5A0D0601 5F4D584C 45505954 3233315F [...ZLXM_TYPE_132]
1818E560 584C5A09 4E555F4D 31035449 C2033233 [.ZLXM_UNIT.132..]
1818E570 C3082102 C9D5D5BF 01B0D2E4 06012C80 [.!...........,..]
1818E580 584C5A0D 59545F4D 315F4550 5A093333 [.ZLXM_TYPE_133.Z]
1818E590 5F4D584C 54494E55 33333103 2202C203 [LXM_UNIT.133..."]
1818E5A0 D5BFC30C D2E4C9D5 B4A2A1B0 2C8001CE [...............,]
1818E5B0 5A0D0601 5F4D584C 45505954 3433315F [...ZLXM_TYPE_134]
这段提示的是什么意思啊?
Doc ID: Note:138652.1 Type: REFERENCE
Last Revision Date: 23-JUN-2005 Status: PUBLISHED
Note: For additional ORA-600 related information please read Note 146580.1PURPOSE:
This article represents a partially published OERI note. It has been published because the ORA-600 error has been
reported in at least one confirmed bug. Therefore, the SUGGESTIONS section of this article may help
in terms of identifying the cause of the error. This specific ORA-600 error may be considered for full publication
at a later date. If/when fully published, additional information
will be available here on the nature of this error.SUGGESTIONS: If the Known Issues section below does not help in terms of identifying
a solution, please submit the trace files and alert.log to Oracle
Support Services for further analysis. Known Issues:
Bug# 3057951 See Note 3057951.8
Wrong histogram calculations when using DBMS_STATS resulting in OERI[19004]
Fixed: 9.2.0.6, 10.1.0.2
Bug# 1245019 See Note 1245019.8
DBMS_STATS to load stats can cause subsequent queries to OERI:19004
Fixed: 8.1.7.0