| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: HP-UX 11i/9.2.0.3/Strange Executions
Actually, I'm quite unaware of ORA-07745 as an execution plan. Can "EXPLAIN
PLAN"
foretell the error?
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:mgogala_at_oxhp.com
-----Original Message-----
From: Daniel Fink [mailto:daniel.fink_at_sun.com]
Sent: Monday, July 21, 2003 6:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: HP-UX 11i/9.2.0.3/Strange Executions
Michael,
When you say 'different execution plans', what are the differences? Is the choice in execution plans causing the ORA-07445? If so, why are the execution plans different (there has to be a reason)? Statistics, parameters, etc. will alter the execution plan choices.
The 7445 definitely deserves a call to Oracle Support (through SAP if need be). 7445s are a royal pain to diagnose (like 600s).
Daniel
"Vergara, Michael (TEM)" wrote:
>
> Hi Everyone!
>
> HELP!
>
> I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend.
> Everything up until now has been OK. However, I now have some
> SAP Transactions (read: data entry forms) that are abending
> unexpectedly.
>
> What's strange is that when we run the transaction on our Stage
> server the explain plan is different, and the query succeeds. In
> PRD, the query is a single-step, and in stage it gets broken out
> into sub-queries and executed there.
>
> I created a report of all the database parameters. There is no
> difference that cannot be explained by the difference in CPUs,
> database name, or application paths. They are fundamentally
> identical.
>
> But the query aborts on PRD. I am attaching the top few lines
> of a typical trace file. ANY help, RTFM references, suggestions,
> incantations, incense, or holy water will be appreciated.
>
> Thanks,
> Mike
>
> *** 2003-07-21 14:52:06.921
> *** SESSION ID:(326.5957) 2003-07-21 14:52:06.886
> Exception signal: 11 (SIGSEGV), code: 0 (unknown code), addr:
0x800000016ede9f30, PC: [0x4000000001331c0c, kghfrmrg()+596]
> Registers:
> r1: 800000010000d9e8 r22: 6e6178d8 sr4:
7df0c00
> rp: 0 arg3: 800000016ede9f28 sr0:
67c9c00
> r3: 40000000013319b8 arg2: c00000006e615fa0 sr1:
d7db000
> r4: 0 arg1: 6e615fa0 sr2:
0
> r5: 0 arg0: c0b38f0000001131 sr3:
0
> r6: 7ffffffc dp: 80000001000ca608 sr5:
6930000
> r7: 0 ret0: 0 sr6:
a814c00
> r8: 80000001007d3798 ret1: 800000000000000 sr7:
67c9c00
> r9: 80000001007d3780 sp: 800003ffbfff6880 cr0:
0
> r10: 0 r31: 6 cr8:
77f6368
> r11: 0 sar: 38 cr9:
77f6378
> r12: 0 pcoqh: 4000000001331c0f ccr:
0
> r13: 10000 pcsqh: 6930000 cr12:
494c008
> r14: 800003ffbfff48c0 pcoqt: 4000000001331a93 cr13:
4a2b008
> r15: 800003ffbfff48c8 pcsqt: 6930000 cr24:
4a2c808
> r16: 40000000003f85d0 eiem: ffffffffffffffff cr25:
4a2a808
> r17: af0 iir: 72f50010 cr26:
4a2c808
> r18: 0 isr: a814c00 mpsfu_hi:
80000001000e36c8
> r19: 800000010000d9e8 ior: 800000016ede9f30 mpsfu_lo:
0
> r20: 0 ipsw: ff080cff1f mpsfu_ov:
41
> r21: 80000001007d2650 goto: 97f68 pad:
0
> *** 2003-07-21 14:52:07.811
> ksedmp: internal or fatal error
> ORA-07445: exception encountered: core dump [kghfrmrg()+596] [SIGSEGV]
[unknown code] [0x800000016EDE9F30] [] []
> Current SQL statement for this session:
> SELECT T_00 . "MATNR" , T_00 . "PRDHA" , T_01 . "MAKTX" FROM "MARA" T_00 ,
"MAKT" T_01 WHERE ( T_01 . "MANDT" = :A0 AND T_01 . "MATNR" = T_00 . "MA
> TNR" ) AND T_00 . "MANDT" = :A1 AND ( ( T_00 . "MATNR" BETWEEN :A2 AND :A3
OR T_00 . "MATNR" BETWEEN :A4 AND :A5 OR T_00 . "MATNR" BETWEEN :A6 AND
> :A7 OR T_00 . "MATNR" BETWEEN :A8 AND :A9 OR T_00 . "MATNR" BETWEEN :A10
AND :A11 OR T_00 . "MATNR" BETWEEN :A12 AND :A13 OR T_00 . "MATNR" BETWEEN
> :A14 AND :A15 OR T_00 . "MATNR" BETWEEN :A16 AND :A17 OR T_00 . "MATNR"
BETWEEN :A18 AND :A19 ) OR T_00 . "MATNR" IN ( :A20 , :A21 , :A22 , :A23 ,
> :A24 , :A25 , :A26 , :A27 , :A28 , :A29 , :A30 , :A31 , :A32 , :A33 ,
:A34 , :A35 , :A36 , :A37 , :A38 , :A39 , :A40 , :A41 , :A42 , :A43 , :A44 ,
> :A45 , :A46 , :A47 , :A48 , :A49 , :A50 , :A51 , :A52 , :A53 , :A54 ,
:A55 , :A56 , :A57 , :A58 , :A59 , :A60 , :A61 , :A62 , :A63 , :A64 , :A65 ,
> :A66 , :A67 , :A68 , :A69 , :A70 , :A71 , :A72 , :A73 , :A74 , :A75 ,
:A76 , :A77 , :A78 , :A79 , :A80 , :A81 , :A82 , :A83 , :A84 , :A85 , :A86 ,
> :A87 , :A88 , :A89 , :A90 , :A91 , :A92 , :A93 , :A94 , :A95 , :A96 ,
:A97 , :A98 , :A99 , :A100 , :A101 , :A102 , :A103 , :A104 , :A105 , :A106 ,
> :A107 , :A108 , :A109 , :A110 , :A111 , :A112 , :A113 , :A114 , :A115 ,
:A116 , :A117 , :A118 , :A119 , :A120 , :A121 , :A122 , :A123 , :A124 , :A
 |
 |