Re: Defragmenting a database

Thanks to Ruth and Gaja for the usual brilliant observations and tips.

I'll be looking at upgrading to 8.1.6 (NT) from 7.3.2 (Netware) soon, and since I'll be reading a lot 8i DBA stuff, I was wondering if the Oracle 8i documentation more or less reflects what y'all are saying about this topic?

regards,
ep

On 10 Oct 2000, at 13:05, Gaja Krishna Vaidyanatha wrote:

Date sent:      	Tue, 10 Oct 2000 13:05:22 -0800
To:             	Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Send reply to:  	ORACLE-L_at_fatcity.com
From:           	Gaja Krishna Vaidyanatha <gajav_at_yahoo.com>
Subject:        	Re: Defragmenting a database

>
> The core issue that we are dealing here, is the stage that is
> being set, for the effects of "honey combing" and fragmentation
> of space within the tablespace, that will occur as a result of
> using "COMPRESS=Y". Having just 1 huge extent (and having many
> of those in your database) is not better performing that even a
> few hundred smaller extents.

...

> --- Ruth Gramolini <rgramolini_at_tax.state.vt.us> wrote:
> > When you import with compress=Y it puts all of the data in the
> > table into
> > one extent. If this is ever going to be a source database for
> > import into
> > another don't do this!!
Received on Wed Oct 11 2000 - 12:59:40 CDT