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

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 13 Jan 2009 17:10:32 +0000
Message-ID: <7765c8970901130910q67f8f050hb876fd74d97e4355_at_mail.gmail.com>

well the <50 is a rule of thumb that requires justification. it's all a bit like extents really.

in the mean time, suggest that obviously 11g is not ready for production use, because it allows automating your partitioning strategy and complete idiots like Tom Kyte and Lillian Hobbs have recommended it.

Niall :)

On Tue, Jan 13, 2009 at 3:31 PM, 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.
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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

Received on Tue Jan 13 2009 - 11:10:32 CST