Re: Using an import as a defrag

bdbafh <bdbafh_at_gmail.com> said:
>On Jan 22, 12:38 pm, howard <pkowa..._at_gmail.com> wrote:
>> I was talking with fellow DBA that told me that I should export my
>> schema, drop it, and re-import it.
>
>What performance problems is the application currently experiencing?
>Is the database growth causing a problem, such as backups failing to
>complete during their maintenance window?

These (above) are the proper questions to ask. If it's working ok (and there's nothing to indicate that it is degrading in some way), don't waste your time.

>The paper by Juan Loiza entitled "how to stop defragmenting and start
>living" isn't returned in a search via google. That paper was
>typically a good start.

It took some time - but reducing the search terms to oracle defragmenting living
provided the anticipated results.

http://www.oracle.com/technology/deploy/availability/pdf/defrag.pdf

Even though the paper dates back to Oracle 8 (educating people to leave behind some practices and rules that were necessary with pre-8 Oracle databases), it still provides a good start. With those practices, there's one thing less to worry about.

-- 
Wolf  a.k.a.  Juha Laiho     Espoo, Finland
(GC 3.0) GIT d- s+: a C++ ULSH++++$ P++@ L+++ E- W+$@ N++ !K w !O !M V
         PS(+) PE Y+ PGP(+) t- 5 !X R !tv b+ !DI D G e+ h---- r+++ y++++
"...cancel my subscription to the resurrection!" (Jim Morrison)