Re: Ora816 - 100% CPU usage after Import

From: Natra <natra_at_libbbero.it>
Date: Thu, 21 Nov 2002 14:26:45 +0100
Message-ID: <arimuk$f3q$1@newsreader.mailgate.org>

> exec dbms_stats.gather_schema_stats('SCHEMA_NAME');

From where I've to execute this command ? (I'm not expert in oracle world...)

> I'm not sure java_pool_size=o is a valid value, I rather suspect you have
> an SGA of

Sorry but what's SGA ?

> My recommendations in order then
>
> 1. *Consider* if 8k is the appropriate block size, if not recreate at file
> system block size. Do this first as it means blowing everything else away
to
> change.

Ok ...

> 2. Reduce the memory requirements of the SGA (or buy more RAM).
mmm SGA ...?

> 3. Analyze the schema.

Can you post the command ?

> As you are going between versions you may get unexpected changes in plan
for
> expensive SQL statements, but the above should be a basic start point.
>

Thanks a lots !!!
Francesco Ortolani Received on Thu Nov 21 2002 - 07:26:45 CST