I hope it's not free. We just paid for it!
> ----------
> From: MacGregor, Ian A.[SMTP:ian_at_SLAC.Stanford.EDU]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Monday, July 03, 2000 11:56 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Partioning Option Free in 8i.
>=20
> Thanks for the input. I am looking atit for both DSS AND OLTP =
databases.
> "Oracle" doesn't believe the partitioning option is free with 8i. =
What's
> your source for your statement to the contrary?
>=20
> Ian MacGregor
> Stanford Linear Accelerator Center
> ian_at_slac.stanford.edu
>=20
> -----Original Message-----
> Sent: Monday, July 03, 2000 1:26 AM
> To: Multiple recipients of list ORACLE-L
>=20
>=20
> Is it for a transactionnal system or for a dss system
> ?
>=20
> In an Oracle document I've read 2 years ago, the
> author said that a table become a candidate to
> partitionning at 2G.=20
> I've partitionned smaller tables than that.
> Manipulating partitions with drop was way faster than
> deleting rows.
>=20
> I'm not aware of a formula for partitionning.=20
>=20
> On 8i, partitionning is free.
>=20
> --- "MacGregor, Ian A." <ian_at_SLAC.Stanford.EDU> a
> =E9crit :<br> > It's time to look at upgrading our
> servers and
> > possibly upgrading our
> > database options. In particular I'm looking at
> > obtaining the partitioning
> > option. However, I don't know the threshold at
> > which partitioning becomes
> > useful; i.e., about what size is a large table? Is
> > this size based on the
> > amount of space the table is consuming or it's
> > actual size? When
> > partitioning to avoid insert hotspots, is there a
> > formula that is used to
> > determine the optimum number of partitions?
> >=20
> > Ian MacGregor
> > Stanford Linear Acclerator Center
> > ian_at_slac.stanford.edu
> > --=20
> > Author: MacGregor, Ian A.
> > INET: ian_at_SLAC.Stanford.EDU
> >=20
> > 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).
>=20
>=20
> =3D=3D=3D=3D=3D
> Stephane Paquette
> DBA Oracle
> stephane_paquette_at_yahoo.com
> spaquette_at_houra.fr
> (33) 01 53 93 06 50
>=20
> __________________________________________________
> Do You Yahoo!?
> Kick off your party with Yahoo! Invites.
> http://invites.yahoo.com/
> --=20
> Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
> INET: stephane_paquette_at_yahoo.com
>=20
> 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).
> --=20
> Author: MacGregor, Ian A.
> INET: ian_at_SLAC.Stanford.EDU
>=20
> 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
Received on Mon Jul 03 2000 - 12:49:58 CDT
