RE: Partitioning

Thanks Syed and Arup for your replies. We are not in archive mode and = are taking cold backups. It is a small warehouse for public health = information and is refreshed once a day. The purpose of the partitioning = is to improve the speed of the ETL process by allowing parallel query = from the ODS. My understanding of the SAME approach is that it averages = out disk access but I am trying to confirm that I can take advantage of = parallel read and write because of the physical partitioning of the = tablespace. Does parallel processing become available due to physical = partitioning or due to logical partitioning?=20

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Arup Nanda Sent: Tuesday, September 07, 2004 10:25 AM Cc: Oracle-L (E-mail)
Subject: Re: Partitioning

As Syed said, performance is not the question if you have striped all = your
disks; but that may not be the case.You may have the RAID sets of a = small
number of disks and it makes sense to create a tablespace in each RAID = set
and then place a partition in each.

There is, however, a more compelling reason for placing partitons in = their
individual tablespaces. It's for backup and recovery reasons.

(1) A block corruption or a loss of datafile will make the respective
tablespace offline, and consequently the contained partition, not all partitions.
(2) A recovery will be on the specific partition.
(3) In the future a partition may be in steady state (more common in =
date
based partitions) and you may want to make the tablespace read only, = take
only one backup and remove the tablespace from the regular backups. = Placing
all partitions in a single tablespace does not allow that.

Hope this helps.

Arup Nanda

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/