Jonathan, do you have a summarized info regrards TB database at you web
site ?
Ted Chyn
In article <937511659.15699.0.nnrp-08.9e984b29_at_news.demon.co.uk>,
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
> Range partitioning and read-only tablespaces
> are particularly critical.
>
> There is a trade-off in partitions between the
> absolute size, the number of partitions which
> is dictated by things like:
> the frequency with which you need to add a partitions
> the nature of queries that cannot use partition elimination
>
> Running partitioning with Parallel Server and parallel query
> also introduces some interesting side-effects. One of my
> hairiest design jobs was a 4 Tb database with 128 nodes,
> and a couple of features of 8.0.3 made life VERY difficult
> (largely fixed by 8.0.5) - haven't had to redo it for 8.1 though which
> would have introduced some nice variants.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> jobrien99_at_my-deja.com wrote in message
<7rrb1d$mlu$1_at_nnrp1.deja.com>...
> >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.
>
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Fri Sep 17 1999 - 07:56:13 CDT
