Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> after adding 6 new datafiles the performance go down

after adding 6 new datafiles the performance go down

From: Alexander Müller <it_mueller_at_web.de>
Date: Sun, 17 Feb 2002 09:11:10 +0100
Message-ID: <a4nojc$cmo$1@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 - 02:11:10 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US