Re: Terabyte databases

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 16 Sep 1999 19:48:07 +0800
Message-ID: <37E0D8F7.232@yahoo.com>

jobrien99_at_my-deja.com wrote:
>
> A couple of questions regarding terabyte databases.
>
> Can your regular Dba cope with the complexity? If not why not?
>
> At what size are tables and indexes candidates for partitioning.
> What Oracle 8 functionality is crucial to a terabyte database ?
>
> What area of Oracle manifests a performance problem that does not occur
> on Gb databases.
>
> Opinions on Oracle and a terabyte database.
>
> Resources for Oracle terabyte database people ?
>
> Thanks People,
> John
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

The larger the database, the more experience a DBA you want...

The main issues with a terabyte database is that its hard to rectify errors...

The rule (for any database) is that you must be able to complete major operations in available time, "major" being

- indexing
- loading
- backing up
- data fixes

etc etc

With a terabyte database, you need a much tighter design....For example, you may get a column wrong and need to update all the values - fine until you realise that updating the 20 billion rows cannot be done in the weekend that you have available.

etc etc

Get an expert in - you never get a large db exactly right first time, but the closer you get at day 1, the less grief you get later.

HTH --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Sep 16 1999 - 06:48:07 CDT