Re: Partition questions

I have to agree, i play with 10G of tables on my PLAY database at home on linux :)

joe

Yosi_at_comhill.com wrote:

> 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
> > (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:
> INET: Yosi_at_comhill.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
Received on Wed Sep 13 2000 - 14:23:13 CDT