Re: 10g on unix. Partitions... Tablespaces... and best practices

From: Suresh Chaganti <chaganti.suresh_at_gmail.com>
Date: Tue, 13 Jan 2009 12:06:57 -0600
Message-ID: <1828353c0901131006h37da8a01n1d6f1acd0a7cf141_at_mail.gmail.com>

Its good line of thinking. You can merge partitions for older data , say each year in its yearly partition once the year is complete. Also for older data, you can make them read-only to save backup time

On Tue, Jan 13, 2009 at 9:31 AM, April Wells <awells_at_netspend.com> wrote:

> Okay, I need to know if there exists a best practices document that I
> can't find anywhere yet.
>
>
>
> I need to find a way to justify (or change my way of thinking).
>
>
>
> I have a data warehouse
>
> I have heavily partitioned data (partition by month) with each partition in
> its own tablespace
>
>
>
> Reasoning
>
> I can make old data read only and speed up backups
>
> I can maintain at the tablespace level
>
> I can compres at the tablespace level
>
>
>
> I have "way too many" tablespaces (this has been suggested more than once
> and has been posed as a problem with my thinking and my judgement) and there
> is supposed to be some document somewhere that says no database needs more
> than 50 tablespaces (odd though about that E-business suite thing for
> years).
>
>
>
> Does anyone have any pointers to good partitioning best practices document
> so I can re-educate myself or something.
>
>
>
> Thanks
>
> April
>
>
>
>
>
> April Wells
>
> SR Oracle DBA
>
> Netspend Corporation
>
> http://www.netspend.com
>
>
>
> ------------------------------
>
>
>
> Confidentiality Notice!
> This electronic transmission and any attached documents or other
> writings are confidential and are for the sole use of the intended
> recipient(s) identified above. This message may contain information
> that is privileged, confidential or otherwise protected from
> disclosure under applicable law. If the receiver of this
> information is not the intended recipient, or the employee, or
> agent responsible for delivering the information to the intended
> recipient, you are hereby notified that any use, reading,
> dissemination, distribution, copying or storage of this information
> is strictly prohibited. If you have received this information in
> error, please notify the sender by return email and delete the
> electronic transmission, including all attachments from your
> system.
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 13 2009 - 12:06:57 CST