RE: Partioning Option Free in 8i.

From: James Bullard <jbullard_at_onvia.com>
Date: Mon, 3 Jul 2000 11:48:40 -0700
Message-Id: <10547.111132@fatcity.com>

Partitioning is not free, the object option is with the enterprise = edition.

-----Original Message-----
From: MacGregor, Ian A. [mailto:ian_at_SLAC.Stanford.EDU] Sent: Monday, July 03, 2000 10:57 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Partioning Option Free in 8i.

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?

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

-----Original Message-----
Sent: Monday, July 03, 2000 1:26 AM
To: Multiple recipients of list ORACLE-L

Is it for a transactionnal system or for a dss system ?

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.

I'm not aware of a formula for partitionning.=20

On 8i, partitionning is free.

"MacGregor, Ian A." <ian_at_SLAC.Stanford.EDU> a =E9crit=A0:<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).

=3D=3D=3D=3D=3D
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50

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

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

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------