Re: Database reorg in Oracle 8?

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Mon, 09 Jun 2003 03:53:13 GMT
Message-Id: <pan.2003.06.09.03.53.11.436924@adelphia.net>

On Sun, 08 Jun 2003 20:45:54 +0200, Heiko wrote:

> First I want to rebuild the index-files, in a second step - I hope I can
> reorganize
> the data-tables.
> We work on Windows 2000 Server with Oracle 8.0.5.0.0

Heiko, your RDBMS is ancient. Please upgrade to at least 8.0.6.3.0, if possible. Preferably, you should upgrade to 8.1.7.4 or 9.2.0.3 (do you feel lucky?). Second, you should tune the application first, then OS and then the instance itself. You might try with _silver_bullet=ON but it has never been a good approach. Rebuilding indexes has to be justified and I doubt that it is in a 10 GB database.

-- 
Mladen Gogala
Software is like sex, it is better when it is free.
Linus Torvalds

Received on Sun Jun 08 2003 - 22:53:13 CDT