Re: Data fragmentation into DB ORACLE

Fragmentation is not a big problem for Oracle databases to handle. Yes, export/import will reduce fragmentation. But I doubt that this will really improve your database performance. For that, you'll need to do some performance tuning. This is a wide ranging topic. I suggest getting a copy of Oracle Performance Tuning by Richard Niemiec on Oracle Press. It will discuss everything you need to resolve your issues.

HTH,
Brian

Giulio Samaritano wrote:
>
> Hi all
> I have this problem due to excessive slow report production:
>
> 1) data fragmentation inside the DB;
>
> For it someone suggested me to introduce some INDEX for
> the critical table into the DB (this to improve performance) or to
> reduce fragmentation
> executing a DB export and a DB import (this operation would improve
> the data
> positioning inside the DB,
> reorganizing data for efficient storage and performance).
>
> Are both operations correct? If yes , I have to execute both or is
> itnecessary only one?
>
> Thanks in advance
> Giulio Samaritano
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================