Re: Defragmenting a database

Unfortunately, our agency won't be upgrading to 8i until hell freezes over so I haven't read the docs.

Sorry,
Ruth
----- Original Message -----
From: "Eric D. Pierce" <PierceED_at_csus.edu> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, October 11, 2000 3:10 PM Subject: 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
>
> >
> > 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!!
> ...
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Eric D. Pierce
> INET: PierceED_at_csus.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Oct 11 2000 - 14:23:36 CDT