Message-Id: <10519.107767@fatcity.com> From: "Katherine Harms" Date: Mon, 05 Jun 2000 19:09:26 -0500 Subject: Re: ORA-07445: exception encountered: core dump [8] [9] [0] We get this error regularly when we use SQR to insert rows that are = created in a file downloaded from our mainframe. It didn't seem possible = to any of us that any normal arithmetic would produce a negative zero, but = SQR manages to that. We routinely check for negative zero and replace it. = Weird, but it works. Katherine Harms Oracle DBA Alegent Health 402-717-1023 kharms@alegent.org >>> jkstill@bcbso.com 06/05/00 12:11PM >>> And don't forget ORA-3113's, a virtually useles error code. As for the ORA-7445's, I get these regularly. Seems that remote connections to our DW will cause them, as there is a 60 minute timeout on logins to the DW. When remote session gets timed out and tries to use the=20 connection, we see a ORa-7445, regardless of the client platform. The server is Solaris 2.6 and Oracle 7.3.3.5. Jared On Mon, 5 Jun 2000, A. Bardeen wrote: > Chatsuda, >=20 > ORA-7445's are a very generic error message. Although > similar to an ORA-600 error, the arguments are usually > irrelevant as the identical circumstances can generate > an error with completely different arguments on > different platforms. You need to log a tar with > Oracle support. They'll need the alert.log and the > trace file generated by the ORA-7445. >=20 > If you know what table(s) were being accessed when the > ORA-7445 occurs, I'd start with running an ANALYZE > TABLE VALIDATE STRUCTURE CASCADE on the tables > involved. When statistics are in place the CBO may be > using an explain plan which does a full table scan, > whereas when you delete the statistics the query might > be using the RBO which will always use an available > index. If there's corruption in the table the index > access might be skipping the corrupt block. >=20 > HTH, >=20 > -- Anita >=20 > --- Chatsuda Watcharakul > wrote: > > Dear All, > > Does anybody experience with the : > > ORA-07445: exception encountered: core dump [8] [9] > > [0] [0] [] []?. > > This cause so many the core dump.=20 > > I investigate that the core dump occure whenever > > the tables/indexes > > has statistics but whenever I delete statistics from > > tables/indexes the > > core dump not generate any more. > > =09 > > My environment is : > > - Oracle Version 7.3.4.4, DEC/OSF1 > > - configure as MTS > > - "CHOOSE" with running statistics every Sunday and > > Wednesday > >=20 > > Your suggest would be appreciate > > Chatsuda=20 > >=20 > > =09 > >=20 > > --=20 > > Author: Chatsuda Watcharakul > > INET: chatsuda.watcharakul@th.origin-it.com=20 > >=20 > > Fat City Network Services -- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California -- Public Internet > > access / Mailing Lists > > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: ListGuru@fatcity.com (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). >=20 > __________________________________________________ > Do You Yahoo!? > Yahoo! Photos -- now, 100 FREE prints! > http://photos.yahoo.com=20 > --=20 > Author: A. Bardeen > INET: abardeen1@yahoo.com=20 >=20 > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (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). >=20 Jared Still Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon jkstill@bcbso.com - Work - preferred address jkstill@teleport.com - private --=20 Author: Jared Still INET: jkstill@bcbso.com=20 Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (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