Re: Urgent help

From: Daniel A. Morgan <damorgan_at_exxesolutions.com>
Date: Mon, 24 Dec 2001 00:40:10 +0000
Message-ID: <3C26796A.68844748@exxesolutions.com>

Likely you created statistics for SYS and/or SYSTEM. Something that should never be done.

Do you analysis on only your application schema(s).

Daniel A Morgan

krishnananda wrote:

> Hi all,
> I am having a strange problem. I would be greatful if anyone can help me
> out. The production database never had any statistics collected for Cost
> Based Optimizer. So I ran the oracle utility to collect the stats i.e
> 'DBMS_STATS.GATHER_SCHEMA_STATS '<SCHEMA>'. After running this logging on
> suddenly takes 5 minutes where it used to take 15 secs. What could the
> problem be?? So we restored the old databse without statistics & now it is
> back to normal it takes 15 secs to log on.
>
> Please reply immdtly.
>
> Thanks & regards,
> Krishnananda
Received on Sun Dec 23 2001 - 18:40:10 CST