Re: Using an import as a defrag
From: Bob Jones <email_at_me.not>
Date: Tue, 22 Jan 2008 20:07:34 -0600
Message-ID: <Gjxlj.937$hI1.442@nlpi061.nbdc.sbc.com>
Date: Tue, 22 Jan 2008 20:07:34 -0600
Message-ID: <Gjxlj.937$hI1.442@nlpi061.nbdc.sbc.com>
"howard" <pkowal74_at_gmail.com> wrote in message
news:8f958845-47b1-4cff-8ebd-ca483964ec34_at_e10g2000prf.googlegroups.com...
> Hello,
>
> I was talking with fellow DBA that told me that I should export my
> schema, drop it, and re-import it.
>
> The reason was that it would act as a defragment and would reorganize
> my extents and therefore I would gain better performance.
>
> I have a small environment; the db is only 100GB. I would only retain
> about 10GB in recovered space if I did this in production.
>
> Is this an accepted practice?
>
That would be the question to ask your fellow DBA. No one here has the data to support his finding. Received on Tue Jan 22 2008 - 20:07:34 CST