RE: Partition questions

From: Diana Duncan <Diana_at_fileFRENZY.com>
Date: Wed, 13 Sep 2000 11:42:48 -0400
Message-Id: <10618.116841@fatcity.com>

Our wonderful Oracle salesentity (hate to deem him a "person") knew we needed Partitioning, sold our CTO on it as one of the major reasons to go with Oracle, and NEVER mentioned that it cost extra. I'll tell you, it was an unwelcome surprise when I had to break the news that it was an "Option". Ouch.

Anyway, to answer the original questions:

1) We use range
2) Never happens in our case
3) Absolutely (but then again, as it was designed to use partitioning, I

never really compared)
4) Simpler, believe it or not (requirement to backup/restore/move account's information MUCH easier)
5) No choice in the matter

Diana

-----Original Message-----
From: Steve Adams [mailto:steve.adams_at_ixora.com.au] Sent: Wednesday, September 13, 2000 5:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: Partition questions

Hi Ian,

I appear to have been under a misapprehension about that, and I know of some customers in Sydney who are using it under the same misapprehension - an expensive mistake at that price! Thanks for the correction.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
@
@ Going to OpenWorld?
@ Catch the Ixora performance tuning seminar too!
@ See http://www.ixora.com.au/seminars/ for details.

-----Original Message-----
Sent: Wednesday, 13 September 2000 15:40 To: Multiple recipients of list ORACLE-L

Perhaps Oracle has included the partioning option in an Olympics Edition avaiable in Australia, but it still costs extra here. I believe about $30.00 per power unit.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

-----Original Message-----
Sent: Tuesday, September 12, 2000 7:51 PM To: Multiple recipients of list ORACLE-L

Hi Bill,

You've already got it. It was only an extra-cost option at 8.0.

range
RTM
Yes
More complex
N/A

-----Original Message-----
Sent: Wednesday, 13 September 2000 7:17
To: Multiple recipients of list ORACLE-L

Hello,

We are a small, but growing data warehouse using Oracle 8.1.6 on Solaris 2.7. We have several tables whose size exceeds 1 GB, and are considering purchasing the partitioning option from Oracle.

Questions:
1) Which partitioning method do you most commonly use,

range, hash or composite?
2) What happens when an existing row in partition A receives

an update which changes a partition key field to make it a member of partition B?
3) Has the use of partitioning improved the performance of

your applications?
4) Has the use of partitioning made the DBA's job simpler

or more complex?
5) Bottom line: do you feel the benefits of partitioning

were worth the extra cost?

Any other comments, guidelines, advice, etc. is/are appreciated. Thanx to all who take the time to respond.

beckerb_at_dgabby.mfldclin.edu
Bill Becker
Marshfield, Wisconsin USA

--
Author: Bill Becker
  INET: beckerb_at_mfldclin.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).
--
Author: Steve Adams
  INET: steve.adams_at_ixora.com.au

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).
--
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
--------------------------------------------------------------------
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).

-- 
Author: Steve Adams
  INET: steve.adams_at_ixora.com.au

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

Received on Wed Sep 13 2000 - 10:42:48 CDT