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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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@xxxxxxxxxxxxx&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/

Other related posts: