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
> 125 , :A126 , :A127 , :A128 , :A129 , :A130 , :A131 , :A132 , :A133 , :A134 , :A135
> , :A136 , :A137 , :A138 , :A139 , :A140 , :A141 , :A142 , :A143
> , :A144 , :A145 , :A146 , :A147 , :A148 , :A149 , :A150 , :A151 , :A152 , :A153 ,
> :A154 , :A155 , :A156 , :A157 , :A158 , :A159 , :A160 , :A161 ,
> :A162 , :A163 , :A164 , :A165 , :A166 , :A167 , :A168 , :A169 , :A170 , :A171 ,
> :A172 , :A173 , :A174 , :A175 , :A176 , :A177 , :A178 , :A179 , :A1
> 80 , :A181 , :A182 , :A183 , :A184 , :A185 , :A186 , :A187 , :A188 , :A189 , :A190 ,
> :A191 , :A192 , :A193 , :A194 , :A195 , :A196 , :A197 , :A198
> , :A199 , :A200 , :A201 , :A202 , :A203 , :A204 , :A205 , :A206 , :A207 , :A208 ,
> :A209 , :A210 , :A211 , :A212 , :A213 , :A214 , :A215 , :A216 , :
> A217 , :A218 , :A219 , :A220 , :A221 , :A222 , :A223 , :A224 , :A225 , :A226 , :A227
> , :A228 , :A229 , :A230 , :A231 , :A232 , :A233 , :A234 , :A23
> 5 , :A236 , :A237 , :A238 , :A239 , :A240 , :A241 , :A242 , :A243 , :A244 , :A245 ,
> :A246 , :A247 , :A248 , :A249 , :A250 , :A251 , :A252 , :A253 ,
> :A254 , :A255 , :A256 , :A257 , :A258 , :A259 , :A260 , :A261 ) ) AND T_01 .
> "SPRAS" = :A262
> ----- Call Stack Trace -----
>
> ---
> ===========================================================================
> Michael P. Vergara
> Oracle DBA
> Guidant Corporation
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Vergara, Michael (TEM)
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
begin:vcard
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard
