Ditto.. Just paid for it..
Shawn M Ferris
Oracle DBA - Time Warner Telecom=20
> -----Original Message-----
> From: Smith, Andy [mailto:andy.smith_at_gwl.com]
> Sent: Monday, July 03, 2000 1:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Partioning Option Free in 8i.
>=20
>=20
> I hope it's not free. We just paid for it!
>=20
> > ----------
> > 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=20
> OLTP databases.
> > "Oracle" doesn't believe the partitioning option is free=20
> 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 /=20
> 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 /=20
> 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
> Author: Smith, Andy
> INET: andy.smith_at_gwl.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
Received on Mon Jul 03 2000 - 15:20:40 CDT
