RE: Partition

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 20 Jun 2003 13:04:24 -0700
Message-ID: <F001.005B6B8A.20030620123013@fatcity.com>

Ishwar

I am fairly new to partitions myself and must relearn the commands each time I need to work with the partitions. So I will speak more to the philosophy of a DBA that doesn't like to end up in a jam.

I get a bad feeling about hashing to get around an immediate problem. I also question the value of an export this large. Have you timed the re-import? It might take so long as to not be of practical value.

My approach in this situation would be to first design how I want my system to be. Lay out the partitions I would like to have, etc. Then create a plan to get to the situation I want. Conduct tests to see what changes can be made in a reasonable time. First create a new partition that will take the newly arriving data so your problem doesn't continue to get worse. Then aim at creating new partitions one at a time that will split the existing too-large partition into smaller partitions in a manageable effort per partition. You may end up creating one each weekend for awhile.

My theory is being DBA of a really large database is similar to being captain of a supertanker. You can't turn a large ship or a large database quickly. You must anticipate problems a long distance off.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] -----Original Message-----
Sent: Friday, June 20, 2003 2:50 PM
To: Multiple recipients of list ORACLE-L

Hey Dennis:

I created a range partition table with the last high_value being maxvalue. The partition key is partner_id (an incremental sequence). Now pmax (the last partition) has become very big and gives "snapshot too old.." while exporting.

Ultimate Plan

I realize that the ultimate solution will be the split the partition pmax, into enough segments so that
the new pmax has no data. Then at this point I will drop the pmax partition. Therefore when new partners come I will add partitions accordingly.

Maybe

But I was thinking If I can make pmax into a hashed subpartition, it will also distribute the data reasonably.
I dont have to have the segments separated by the partner_id because the data are not evenly distributed to the partners. partner_id , count(*)

  1             4646545542
  2             11164546466

... and so on..

Thanks very much for your help.

Ishwar

-----Original Message-----
DENNIS WILLIAMS
Sent: Friday, June 20, 2003 3:10 PM
To: Multiple recipients of list ORACLE-L

Ishwar - What Oracle version. Just off the top of my head, I think that 8i only allows the subpartition to be hashed. What is your goal?

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] -----Original Message-----
Sent: Friday, June 20, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L

Hey,

Can anyone say if there is a way to breakup an existing partition into subpartitons. The partition contains data.

Thx
Ishwar.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ishwar Tewari
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ishwar Tewari
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Received on Fri Jun 20 2003 - 15:04:24 CDT