And the reason it's way off is because there are far too many variables to
be included in such a sizing estimate. That's why we no longer provide
them. They were the wrong approach. The only valid way of determining
sizing is to load a test amount of data the is valid for any data skew and
extrapolate from that, or use historical information if you already have
that.
--
HTH. Additions and corrections welcome.
Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"
Now got a life back again that the book is released!
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
"Maggie Evans" <maggie-evans_at_home.com> wrote in message
news:38vu7.44111$L8.11043294_at_news2.rdc1.bc.home.com...
> The formula they provide in the DBA text is way off. 5% of a billion
records
> really
> adds up.
>
> Can somebody point me to a
> more accurate formula.
>
> Thanks in advance for any help
> owen brandon in victoria, b.c.
>
>
>
>
>
Received on Thu Oct 04 2001 - 09:52:52 CDT
