Re: Data fragmentation into DB ORACLE

P.S. For Oracle specific questions of this type, you may want to post to either the comp.databases.oracle.misc or comp.databases.oracle.server newsgroups.

HTH,
Brian

Brian Peasland wrote:
>
> 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!
> ========================================
 

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