-
Internal error code
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
-
call oracle support and use their 0ra-600 lookup tool
-
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
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|