Chatsuda:
In your analyze table, if your estimate percentage is 51, Oracle will
perform compute statistics.
If you want to save some time, maybe you can lower your percentage to 25 -
35 %. That shoule be enough.
Regards
> Kevin Tsay
> Intira Corporation
>
>
-----Original Message-----
From: Chatsuda Watcharakul
[mailto:chatsuda.watcharakul_at_th.origin-it.com]
Sent: Tuesday, June 06, 2000 2:19 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-07445: exception encountered: core dump [8] [9] [0] [0]
[
Dear Anita,
I also analyze on access tables, there is no error.
ANALYZE TABLE <table> VALIDATE STRUCTURE CASCADE
However, Oracle will generate a lot of core dump if we run any query
on tables with statistics.
Without statistics, there is no problem.
Do you have any idea to analyze statistics? We analyze every table
with this command:
Analyze table <table> estimate statistics for table sample 51
percent;
Analyze table <table> estimate statistics for all columns sample 51
percent;
Analyze table <table> compute statistics for all indexes;
Regards,
Chatsuda
> -----Original Message-----
> From: A. Bardeen [SMTP:abardeen1_at_yahoo.com]
> Sent: Monday, June 05, 2000 21:07
> To: Multiple recipients of list ORACLE-L
> Subject: Re: ORA-07445: exception encountered: core dump [8] [9] [0]
> [0] [] []
>
> 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!?
> Yahoo! Photos -- now, 100 FREE prints!
> http://photos.yahoo.com
> --
> Author: A. Bardeen
> INET: abardeen1_at_yahoo.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).
--
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
Received on Tue Jun 06 2000 - 08:37:27 CDT
