Oracle Database Discussions

i have facing this error while inserting records in partitcular table. we open a transaction and inserts data in 5 table four table data successfully laoded but at table five where data is only 5000 records statement with fails. when i run this insert thorugh any tool like sql developer its completed in 10 second . i'm posting some portion of my trace file


Trace file d:\app\remote\diag\rdbms\orcl\orcl\trace\orcl_ora_2992.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V5.2 Service Pack 2
CPU : 8 - type 8664, 2 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:7002M/12286M, Ph+PgF:8609M/13805M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 27
Windows thread id: 2992, image: ORACLE.EXE (SHAD)


*** 2009-07-02 12:25:23.453
*** SESSION ID:(511.1247) 2009-07-02 12:25:23.453
*** CLIENT ID:() 2009-07-02 12:25:23.453
*** SERVICE NAME:(ORCL) 2009-07-02 12:25:23.453
*** MODULE NAME:(metadataserver.vshost.exe) 2009-07-02 12:25:23.453
*** ACTION NAME:() 2009-07-02 12:25:23.453

Incident 140218 created, dump file: d:\app\remote\diag\rdbms\orcl\orcl\incident\incdir_140218\orcl_ora_2992_i140218.trc
ORA-00600: internal error code, arguments: [6780], [], [], [], [], [], [], [], [], [], [], []

qerpxFetch
rpa:0x000000027FDD7728 rpm:0x0000000022DDC258
----- Current SQL Statement for this session (sql_id=7dvyzzx6dqy20) -----
INSERT /* APPEND PARALLEL(STK_JULY2_DG5, 4) NOLOGGING */ INTO "STK_JULY2_DG5" (DG5_ID, STK_JULY2_DG5."TXN_ITEM_VOIDS_QTY", STK_JULY2_DG5."TXN_ITEM_REFUNDS_QTY", STK_JULY2_DG5."TXN_ITEM_DISCS_QTY", STK_JULY2_DG5."TXN_ITEM_SALES_QTY", STK_JULY2_DG5."TXN_TENDER_QTY", STK_JULY2_DG5."TXN_TENDER_TYPES_QTY", STK_JULY2_DG5."TXN_CASH_QTY", STK_JULY2_DG5."TXN_CARD_QTY", STK_JULY2_DG5."TXN_CHQ_QTY", STK_JULY2_DG5."TXN_VOUCHER_QTY", STK_JULY2_DG5."TXN_CREDIT_NOTE_QTY", STK_JULY2_DG5."TXN_GIFT_CARD_QTY", STK_JULY2_DG5."TXN_TYPE_CODE", STK_JULY2_DG5."TXN_DOC_NO", STK_JULY2_DG5."TXN_MIXED_PAYMENT_FLAG", STK_JULY2_DG5."TXN_ITEM_VOID_AMT", STK_JULY2_DG5."TXN_ITEM_REFUND_AMT", STK_JULY2_DG5."TXN_ITEM_DISC_AMT", STK_JULY2_DG5."TXN_SSP", STK_JULY2_DG5."TXN_BALANCE", STK_JULY2_DG5."TXN_CHANGE", STK_JULY2_DG5."TXN_BASKET_DISC_QTY", STK_JULY2_DG5."TXN_NM_DISC_LINE_COUNT", STK_JULY2_DG5."TXN_STAFF_FLAG", STK_JULY2_DG5."TXN_DESCRIPTION", STK_JULY2_DG5."OPERATIONAL_DATE") SELECT GNSQ_STK_JULY2_DG5.NEXTVAL, NEWDATA.* FROM ( SELECT /* PARALLEL(GN_FLAT_IN_TABLE, 4) PARALLEL(STK_JULY2_DG5, 4) */ DISTINCT GN_FLAT_IN_TABLE."TXN_ITEM_VOIDS_QTY", GN_FLAT_IN_TABLE."TXN_ITEM_REFUNDS_QTY", GN_FLAT_IN_TABLE."TXN_ITEM_DISCS_QTY", GN_FLAT_IN_TABLE."TXN_ITEM_SALES_QTY", GN_FLAT_IN_TABLE."TXN_TENDER_QTY", GN_FLAT_IN_TABLE."TXN_TENDER_TYPES_QTY", GN_FLAT_IN_TABLE."TXN_CASH_QTY", GN_FLAT_IN_TABLE."TXN_CARD_QTY", GN_FLAT_IN_TABLE."TXN_CHQ_QTY", GN_FLAT_IN_TABLE."TXN_VOUCHER_QTY", GN_FLAT_IN_TABLE."TXN_CREDIT_NOTE_QTY", GN_FLAT_IN_TABLE."TXN_GIFT_CARD_QTY", GN_FLAT_IN_TABLE."TXN_TYPE_CODE", GN_FLAT_IN_TABLE."TXN_DOC_NO", GN_FLAT_IN_TABLE."TXN_MIXED_PAYMENT_FLAG", GN_FLAT_IN_TABLE."TXN_ITEM_VOID_AMT", GN_FLAT_IN_TABLE."TXN_ITEM_REFUND_AMT", GN_FLAT_IN_TABLE."TXN_ITEM_DISC_AMT", GN_FLAT_IN_TABLE."TXN_SSP", GN_FLAT_IN_TABLE."TXN_BALANCE", GN_FLAT_IN_TABLE."TXN_CHANGE", GN_FLAT_IN_TABLE."TXN_BASKET_DISC_QTY", GN_FLAT_IN_TABLE."TXN_NM_DISC_LINE_COUNT", GN_FLAT_IN_TABLE."TXN_STAFF_FLAG", GN_FLAT_IN_TABLE."TXN_DESCRIPTION", GN_FLAT_IN_TABLE."OPERATIONAL_DATE" FROM GN_FLAT_IN_TABLE LEFT OUTER JOIN "STK_JULY2_DG5" ON NVL(GN_FLAT_IN_TABLE."TXN_ITEM_VOIDS_QTY", -1033) = NVL(STK_JULY2_DG5."TXN_ITEM_VOIDS_QTY", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_ITEM_REFUNDS_QTY", -1033) = NVL(STK_JULY2_DG5."TXN_ITEM_REFUNDS_QTY", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_ITEM_DISCS_QTY", -1033) = NVL(STK_JULY2_DG5."TXN_ITEM_DISCS_QTY", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_ITEM_SALES_QTY", -1033) = NVL(STK_JULY2_DG5."TXN_ITEM_SALES_QTY", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_TENDER_QTY", -1033) = NVL(STK_JULY2_DG5."TXN_TENDER_QTY", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_TENDER_TYPES_QTY", -1033) = NVL(STK_JULY2_DG5."TXN_TENDER_TYPES_QTY", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_CASH_QTY", -1033) = NVL(STK_JULY2_DG5."TXN_CASH_QTY", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_CARD_QTY", -1033) = NVL(STK_JULY2_DG5."TXN_CARD_QTY", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_CHQ_QTY", -1033) = NVL(STK_JULY2_DG5."TXN_CHQ_QTY", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_VOUCHER_QTY", -1033) = NVL(STK_JULY2_DG5."TXN_VOUCHER_QTY", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_CREDIT_NOTE_QTY", -1033) = NVL(STK_JULY2_DG5."TXN_CREDIT_NOTE_QTY", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_GIFT_CARD_QTY", -1033) = NVL(STK_JULY2_DG5."TXN_GIFT_CARD_QTY", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_TYPE_CODE", -1033) = NVL(STK_JULY2_DG5."TXN_TYPE_CODE", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_DOC_NO", -1033) = NVL(STK_JULY2_DG5."TXN_DOC_NO", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_MIXED_PAYMENT_FLAG", -1033) = NVL(STK_JULY2_DG5."TXN_MIXED_PAYMENT_FLAG", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_ITEM_VOID_AMT", -1033) = NVL(STK_JULY2_DG5."TXN_ITEM_VOID_AMT", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_ITEM_REFUND_AMT", -1033) = NVL(STK_JULY2_DG5."TXN_ITEM_REFUND_AMT", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_ITEM_DISC_AMT", -1033) = NVL(STK_JULY2_DG5."TXN_ITEM_DISC_AMT", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_SSP", -1033) = NVL(STK_JULY2_DG5."TXN_SSP", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_BALANCE", -1033) = NVL(STK_JULY2_DG5."TXN_BALANCE", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_CHANGE", -1033) = NVL(STK_JULY2_DG5."TXN_CHANGE", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_BASKET_DISC_QTY", -1033) = NVL(STK_JULY2_DG5."TXN_BASKET_DISC_QTY", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_NM_DISC_LINE_COUNT", -1033) = NVL(STK_JULY2_DG5."TXN_NM_DISC_LINE_COUNT", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_STAFF_FLAG", -1033) = NVL(STK_JULY2_DG5."TXN_STAFF_FLAG", -1033) AND NVL(GN_FLAT_IN_TABLE."TXN_DESCRIPTION", -1033) = NVL(STK_JULY2_DG5."TXN_DESCRIPTION", -1033) AND NVL(GN_FLAT_IN_TABLE."OPERATIONAL_DATE", '14-AUG-1947') = NVL(STK_JULY2_DG5."OPERATIONAL_DATE", '14-AUG-1947') WHERE "STK_JULY2_DG5"."DG5_ID" IS NULL ) NEWDATA
ERROR parallelizer slave or internal
qbas:11994
pgakid:3 pgadep:0
qerpx: error stack: OER(600)
qbas_qerpxs: 11994
dfo_qerpxs: 0x000000027FDD3070 dfo1_qerpxs: 0x000000027FDD95F0
ntq_qerpxs: 3 ntqi_qerpxs: 0
nbfs_qerpxs: 0
nobj_qerpxs: 2 ngdef_qerpxs: 2
mflg_qerpxs: 0x0
slave set 1 DFO dump:
kkfdo: (0x000000027FDD95F0)
kkfdo->kkfdochi: (0x0000000000000000)
kkfdo->kkfdopar: (0x000000027FDD9528)
kkfdo->kkfdonxt: (0x000000027FDD9528)
kkfdo->kkfdotqi: 0
kkfdo->kkfdontbl: 1
kkfdo->kkfdongra: 1
kkfdo->kkfdofigra: 0
kkfdo->kkfdoflg: 0x2002
kkfdo->kkfdooct: 2
kkfdo->kkfdonumeopn: 0
Output table queue: (0x000000027FDCED80)
kxfqd : 000000027FDCCD40