Internal error code

[rashadyell]

Hi,

i am getting following error in alert log file ahen user run long query with table joining. how to resolve this issue? and the following is the part of trace file.

ORA-00600: internal error code, arguments: [20084], [184559691], [10], [180363385], [6], [], [], []


*** 2009-07-26 16:52:49.000
*** SESSION ID:(128.4236) 2009-07-26 16:52:49.000
FATAL ERROR IN TWO-TASK SERVER: error = 12571
*** 2009-07-26 16:52:49.000
ksedmp: internal or fatal error
Current SQL statement for this session:
UPDATE OT_JOB_HEAD SET JH_DT=:1,JH_DOC_SRC_LOCN_CODE=:2,JH_TXN_CODE=:3,JH_NO=:4,JH_AMD_NO=:5,JH_AMD_DT=:6,JH_AMD_RES_CODE=: 7,JH_REF_FROM=:8,JH_REF_TXN_CODE=:9,JH_REF_NO=:10,JH_REF_FROM_NUM=:11,JH_JOB_NO=:12,JH_DESC_1=:13,JH _JOB_TYPE=:14,JH_SERVICE_TYPE=:15,JH_SERVICE_CENTER=:16,JH_CHASSIS_NO=:17,JH_REG_NO=:18,JH_GATE_PASS =:19,JH_IN_TIME=:20,JH_OUT_TIME=:21,JH_MILEAGE=:22,JH_LPO_NO=:23,JH_ROUTING_NO=:24,JH_BAY_NO=:25,JH_ SERVICE_ADVISOR=:26,JH_BOOKED_BY=:27,JH_CUST_CODE=:28,JH_CUST_NAME=:29,JH_ADDR_CODE=:30,

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedmp+147 CALLrel _ksedst+0
__VInfreq__opitsk+3 CALLrel _ksedmp+0 2 25C34D4 311B
eb


any help is appreciated.

thanks in advance

regards,

Rashad

[davey23uk]

call oracle support and use their 0ra-600 lookup tool

[PAVB]

Something does not adds up here.

Poster states "query with table joining"...
Trace shows "UPDATE OT_JOB_HEAD SET..."
ORA-600 [20084] usually refers to indexing related issues; see Metalink 138678.1