Re: ORA-07445: exception encountered: core dump [8] [9] [0] [0] [] []

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Mon, 5 Jun 2000 05:56:34 -0700 (PDT)
Message-Id: <10519.107692@fatcity.com>

Chatsuda,

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.

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.

HTH,

• Anita
  • 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.
    > 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.
    >
    > My environment is :
    > - Oracle Version 7.3.4.4, DEC/OSF1
    > - configure as MTS
    > - "CHOOSE" with running statistics every Sunday and
    > Wednesday
    >
    > Your suggest would be appreciate
    > Chatsuda
    >
    >
    >
    > --
    > Author: Chatsuda Watcharakul
    > INET: chatsuda.watcharakul_at_th.origin-it.com
    >
    > 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).
    

    ---

Do You Yahoo!? Received on Mon Jun 05 2000 - 07:56:34 CDT