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_at_alegent.org
>>> jkstill_at_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 <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
> <chatsuda.watcharakul_at_th.origin-it.com> 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_at_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_at_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_at_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_at_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_at_bcbso.com - Work - preferred address
jkstill_at_teleport.com - private
--=20
Author: Jared Still
INET: jkstill_at_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_at_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
Received on Mon Jun 05 2000 - 19:09:26 CDT
