Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: When and How to run dbms_stats.gather

Re: When and How to run dbms_stats.gather

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 1 Sep 2003 08:58:59 +0100
Message-ID: <biuui3$nad$1$8300dec7@news.demon.co.uk>

It seems highly likely if you have a problem it will be with IOTs. (Is this with a compressed primary key ?)

In earlier versions of dbms_stats, an attempt to execute dbms_stats against an IOT would turn silently into an ANALYZE after raising a trapped exception.

Are you creating histograms as you go ? Are you using anything like the AUTOSAMPLE option ?

If you haven't done so already, you could try running your crashing dbms_stats calls with sql_trace switched on so that you can see if one particular bit of the recursive SQL is causing the problem.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

____Finland__September 22nd - 24th
____Norway___September 25th - 26th


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____USA_(CA, TX)_August
____USA__October
____UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Andras Kovacs" <andkovacs_at_yahoo.com> wrote in message
news:412ebb69.0308190845.1e3d6e31_at_posting.google.com...

> I think we all share the same point of view regarding dbms_Stats.
> However there was a person really pushing hard on logging out users
> from the system (this was our third party software provider). We are
> in the utility business so the system is up 24 hours a day and 365
> days a year. My manager will take of this other company.
>
> Now regarding dbms_stats causing system crash. Sounds crazy but
> happens with IOT tables ! Oracle has a few troubles with IOTs. We
have
> been testing Oracle 9.2.0.3 and we encountred some major problems
that
> prevents us from upgrading oracle. We have 5 Tars opened on IOTs and
> we are working on the test cases.
Received on Mon Sep 01 2003 - 02:58:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US