Re: SOS what should I do with this mess?

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 2 Apr 2002 12:33:04 +1000
Message-ID: <a8b5bm$a3b$1@lust.ihug.co.nz>

Short of re-writing the app's code, there's not a lot you can do. If the app was written with rule-based in mind, then the worst thing you can do is switch to cost-based.

So learn to live with it.

Regards
HJR

--
------------------------------------------
Resources for Oracle : www.hjrdba.com
============================


"Joe Sath" <dbadba62_at_hotmail.com> wrote in message
news:UF8q8.11666$id3.4201_at_nwrddc02.gnilink.net...


> One of my new client, their previous DBA NEVER analyze their tables even

> though he set his optimizer_mode = choose, the whole production is running

> as RULE based.

>

> When I analyzed the database( excepte sys,system), the whole database

become


> so slow, I have to delete all the statistics in order for the production

to


> go on.

>

> What should I do with it?  Leave it running as rule based?  It is kind of

> pain that you can not take advantage of cost optimizer.

>

> What steps should I take to convert it smoothly to cost based one?

>

> Thanks for your help

>

>

Received on Mon Apr 01 2002 - 20:33:04 CST