Re: Usage of the dbms_stats.gather_database_stats() procedure

  • From: Dennis Williams <oracledba.williams@xxxxxxxxx>
  • To: sorr@xxxxxxxxxxxx
  • Date: Mon, 13 Feb 2006 12:40:32 -0600

>  Steve,
 I've just become aware of an instance that has 130 schemas with a total of
> 15,000 tables, 12,700 of which have no optimizer statistics. Even though
> things run relatively well without the stats we are sometimes bitten by poor
> performance without warning and have to compute stats as a fix
I'm confused. So you have no statistics or just some?
   My concern is that this could easily become a people problem. If most
queries are running fine, then when you apply statistics some queries will
run worse. Maybe much worse. Then whose head will they be looking for? Been
    Here is the way I would approach it.
 1. Associate schemas with groups of users and see if you can roll out
statistics gradually.
 2. Configure a test database, and generate statistics.
 3. Meet with representatives of each group of users, and explain what you
intend to do. Ask that they test their critcal queries.
 4. Announce a schedule of implementation for each group.
With luck you might survive.

Dennis Williams

Other related posts: