RE: Partition questions

BTW, For a 1G data warehouse, I think you could get by more easily WITHOUT partitioning. I'm not sure where I'd draw the line about what size to begin partitioning, but IMVHO 1G is relatively small and the performance benefit may NOT even be worth the maintenance.

FWIW, Yosi

> -----Original Message-----
> From: Diana Duncan [mailto:Diana_at_fileFRENZY.com]
> Sent: Wednesday, September 13, 2000 12:52 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Partition questions
>
>
> 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-----
> Sent: Wednesday, September 13, 2000 5:50 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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.
>
> 1) range
> 2) RTM
> 3) Yes
> 4) More complex
> 5) N/A
>
> @ 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 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
> (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: Diana Duncan
> INET: Diana_at_fileFRENZY.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
Received on Wed Sep 13 2000 - 11:44:21 CDT