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

On Nov 11, 2:33 am, Robert Klemme <shortcut..._at_googlemail.com> wrote:
> On 10.11.2008 21:52, zigzag..._at_yahoo.com 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