RE: Partition questions

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-----
From: Steve Adams [mailto:steve.adams_at_ixora.com.au] Sent: Tuesday, September 12, 2000 7:51 PM To: Multiple recipients of list ORACLE-L Subject: RE: Partition questions

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