Metalink: 241160.1 ALERT: ORA-7445 Signalled from Different Functions on 64-bit HP-UX.
Versions 9.2.0.2 and 9.2.0.3
> -----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
> > 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: mvergara_at_guidant.com
> >
> > 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
Received on Mon Jul 21 2003 - 16:52:22 CDT
