Re: after adding 6 new datafiles the performance go down

From: Svend Jensen <Master_at_OracleCare.Com>
Date: Sun, 17 Feb 2002 12:13:08 +0100
Message-ID: <3C6F9044.6010700@OracleCare.Com>

Alexander Müller wrote:

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

Adding datafiles to tablespaces seldom gives performance problems. Can you clearify the type of reorganisation done?

/Svend Jensen Received on Sun Feb 17 2002 - 05:13:08 CST