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

From: <>
Date: Tue, 11 Nov 2008 05:05:10 -0800 (PST)
Message-ID: <>

On Nov 11, 2:33 am, Robert Klemme <> wrote:
> 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

Since my database is 70% read and 30% write, I would think effect will last noger if any performance improvements are ontained because of reduced no of blocks. Received on Tue Nov 11 2008 - 07:05:10 CST

Original text of this message