Re: Are there performancebenefits to reorganizing database-using export/import?

From: Robert Klemme <>
Date: Tue, 11 Nov 2008 08:33:37 +0100
Message-ID: <>

On 10.11.2008 21:52, wrote:
> Are there any benefits to reorganize database using export/import,
> i.e., we will do a full export of existing database and then delete
> all objects from application schemas and do schema imports.

> I have heard different views on reorganization. Some people say it is
> useless, some people say it can improve performance since data will be
> compacted in fewer blocks.

Also agree with Joel: First you should determine whether physical properties (block usage etc.) are actually limiting performance. Assuming that this has been established, an important question is: how much effort does this reorganizing take and how long does the effect last? If it takes a day (during which you might have to go offline) but the effect is gone after a week because of the nature of your workload, it's probably not worth the effort and risk.

Kind regards

        robert Received on Tue Nov 11 2008 - 01:33:37 CST

Original text of this message