Re: What is the trick to calculating the size of an index in 8.1.7 on a 64 bit machine?

Hooray! Common sense prevails!

Paul

"Pete Sharman" <peter.sharman_at_oracle.com> wrote in message news:hR_u7.62$78.10660_at_inet16.us.oracle.com...
> 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 - 12:41:45 CDT