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

• Original Message ----- From: <SJHussain_at_alfransi.com.sa> To: <dofreeman_at_state.pa.us> Cc: "Oracle-L (E-mail)" <oracle-l_at_freelists.org>; <oracle-l-bounce_at_freelists.org> Sent: Tuesday, September 07, 2004 9:48 AM Subject: Re: Partitioning

>
>
>
>
> Since you have RAID technology, I believe, no need to worry about where to
> keep your partitions, either in the same tablespace or in the different
> tablespaces.
>
> Best Regards,
>
> Syed Jaffar Hussain
> OCP, DBA Consultant
>
>
>
>
> "Freeman, Donald"
> <dofreeman_at_state.
> pa.us> To
> Sent by: "Oracle-L (E-mail)"
> oracle-l-bounce_at_f <oracle-l_at_freelists.org>
> reelists.org cc
>
> Subject
> 09/07/2004 04:44 Partitioning
> PM
>
>
> Please respond to
> dofreeman_at_state.p
> a.us
>
>
>
>
>
>
> The system is Oracle 9.2.0.5 on Windows 2000. We want to partition some =
> of our tables for performance. The data is loaded on 7 disks striped =
> and mirrored. My question is can I just create partitions in the =
> original tablespace and benefit from partitioning or do the partitions =
> have to be in separate tablespaces? Is the parallelism enabled at the =
> logical level through multiple partitions in different tablespaces or =
> just physically through striping?
>
> Don Freeman
> Database Administrator 1
> Pennsylvania Dept of Health
> Bureau of Information Technology
>
>
> --
> To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
> To search the archives - http://www.freelists.org/archives/oracle-l/
>
>
> Visit us on www.alfransi.com.sa
> ====== Banque Saudi Fransi - Privacy Notice ======
> This message is intended only for the person or entity to which it is
> addressed and may contain confidential and/or privileged material. Any
> use of this information by persons or entities other than the intended
> recipient is prohibited. If you have received this in error, please
> contact the sender and delete the material from your computer. Any
> opinions and other information contained in this message that do not
> relate to the official business of Banque Saudi Fransi shall be
> understood as neither given or endorsed by it. Although precautions
> have been taken to ensure no viruses are present in this email, BSF
> cannot accept responsibility for any loss or damage arising from the
> use of this email or attachments.
> ====== Banque Saudi Fransi - Privacy Notice ======
>
> --
> To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
> To search the archives - http://www.freelists.org/archives/oracle-l/
>

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