Performance decrease dramaticcaly by using statistics

From: Gijanto, Ruud <RGijanto_at_ctgzorg.nl>
Date: Wed, 27 Feb 2002 11:10:12 +0100
Message-ID: <7C3B10C067C2D2119CE60020354473CE691A0D@SPICA>

SYS is not the schema owner and the datadictionary is not filled with statistics and the statistics is is calculated with compute statistics and up to date.

Ruud

-----Oorspronkelijk bericht-----
Van: sharkdba_at_yahoo.com (Sharkie) [mailto:sharkdba_at_yahoo.com] Gepost op: dinsdag 26 februari 2002 20:17 Gepost naar: server
Discussie: Performance decrease dramaticcaly by using statistics Onderwerp: Re: Performance decrease dramaticcaly by using statistics

"Gijanto, Ruud" <RGijanto_at_ctgzorg.nl> wrote in message news:<7C3B10C067C2D2119CE60020354473CE6806C7_at_SPICA>...
> OPTIMIZER_MODE = CHOOSE
> Without statistics is the elapsed time of a jobs/transactions
> approximately 1 minute.
> With statistics increase the elapsed-time to min. 25 minutes.
> I don't understand why this happened.

Not sure if this is your problem, but
it could be that you're analyzing objects owned by the SYS schema.

Don't do this, since these objects are already optimized, and analyzing them might decrease performance. Received on Wed Feb 27 2002 - 04:10:12 CST