Re: Ora816 - 100% CPU usage after Import

"Natra" <natra_at_libbbero.it> wrote in message news:arimuk$f3q$1_at_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...)

SQL*Plus when connected as system.

>
> > 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 ?

Ah.... SGA = system global area. Take a look at http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76965/c01i ntro.htm#18748 for an explanation of Oracle's memory structure. In fact you might well find the whole Oracle Concepts manual useful.

>
> > 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 ...?

see above.

>
>
> > 3. Analyze the schema.
> Can you post the command ?

I already did! Its the dbms_stats command above. However it does show that you are rather new to Oracle, so the normal advice would be to read the Concepts documentation and also perhaps to get the help of a more experienced DBA.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************