Re: 10g on unix. Partitions... Tablespaces... and best practices
From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Wed, 14 Jan 2009 11:32:41 -0600
Message-ID: <de807caa0901140932q188e16aesad505d6cddf83145_at_mail.gmail.com>
April,
Date: Wed, 14 Jan 2009 11:32:41 -0600
Message-ID: <de807caa0901140932q188e16aesad505d6cddf83145_at_mail.gmail.com>
April,
Couple of thoughts for you:
Are you considering ASSM?
What size of datafiles are you and your storage team comfortable with? At the extreme, a couple of tablespaces makes administration easy. But if you have to do something with a multi-terrabyte tablespace, that could take a loooong time. And recovering a single small datafile is much faster than recovering a huge datafile.
What are the update and downtime requirements for this data warehouse? Is it updated weekly or updated continuously? How much downtime can be tolerated in case of a failure?
Dennis Williams
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 14 2009 - 11:32:41 CST