Using an import as a defrag
Date: Tue, 22 Jan 2008 09:38:31 -0800 (PST)
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?
In 10g, I have worked with segment advisor and the reorganize tools, but they seem almost useless.
Howard Received on Tue Jan 22 2008 - 11:38:31 CST