Re: Defragmentation

From: Patrick <Groeps_at_mail.interpac.be>
Date: 1998/09/18
Message-ID: <01bde2fd$dea4fdc0$3bfa4ec2@internet>#1/1

I would test the following :
Create new tbs/datafile
Perform a direct path select/insert with /* APPEND */ for your largest and most fragmented tables in new tablespace/datafile. (direct path divides time by 2)
drop table in old datafile
coalesce free space in old tbs
Look at fragmentation and largest available extents in old datafile with tablespace manager
When result satisfactory, re-insert in old datafile. The result will be obviously less performant than exp/imp

Patrick Wtterwulghe
Oracle DBA

Robert Jungerius <rjungerius_at_death-to-spam.cetecint.com> wrote in article <01bde2d9$a51a8080$270164bf_at_wks139>...
> Hello, I'm a Oracle DBA working with Oracle 7.3.4 on the NT4 platform.
> The only way of defragmentation I know of is to export, drop user, create
> user and import.
> This is impossible with databases of 10Gb or more, because the downtime
is
> unacceptable and the
> diskspace needed for this operation is outrageous!
> I'm having serious problems keeping the databases of all customers
running
> smoothly!
>
> How do you defragment a very large database?
> And does anybody have some tips concerning performance tuning?
>
> Thanx in advance.
>
> Robert Jungerius,
> DBA, Software Engineer @ CETEC BV
> rjungerius_at_yahoo.com
>
Received on Fri Sep 18 1998 - 00:00:00 CDT