Re: after adding 6 new datafiles the performance go down

From: Stephen Ashmore <sashmore_at_neonramp.com>
Date: Sun, 17 Feb 2002 08:28:57 -0600
Message-ID: <u6vfh4a3t4t3eb@corp.supernews.com>

Your database may be having trouble completeing checkpoints.

Determine how often it is checkpointing. You can set init.ora parameter log_checkpoint_to_alert to true.

Also make sure you are not getting a bunch of checkpoint not complete errors in your alert.log.

If you are doing excessive checkpoints you may try increasing the size of log_buffer.

You may also try using multiple db_writers or some io_slaves.

Good luck!

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

"Alexander Müller" <it_mueller_at_web.de> wrote in message news:a4nojc$cmo$1_at_news.online.de...
> Hi,
> i'm adding 3 datafiles and 3 idx-datafiles in two tablespaces, and then we
> reorganize parts of the tablespace in this datafiles. After reorganize the
> database was with the factor 10 slower.
>
> we bring the sga after this action up and we move the files to another
> disks. But it would be not better. At time we have in both tablespaces 27
GB
> / Oracle 7.3.4.5.0 / HP-UX 10.20
>
>
>
>
> --
> best regards
>
> Alexander Müller
>
>
Received on Sun Feb 17 2002 - 08:28:57 CST