Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: separate data/inidex
I don't disagree. But I put the question out here again. Does anyone have anything
better than the table Loney and Theriault created? Or is all of the discussion here
just off-the-cuff remarks not based on actual testing?
Thanks.
Daniel Morgan
Connor McDonald wrote:
> Daniel A. Morgan wrote:
> >
> > Great ... we are 70% of the way there. Lets see if we can but the top on the box
> > and tie a ribbon around it.
> >
> > I am looking at at Kevin Loney and Marlene Theriault's book Oracle 8i DBA
> > Handbook, page 97, section title I/O Contention Among Datafiles. And the next
>
> [snip]
>
> Here is quote from a Loney book (can't remember the title offhand)
>
> "...you should specify a very low value for pctfree ...the space used by
> deleted entries within an index is not reused..."
>
> which pretty much sums up the amount of credence I place on that book
>
> --
> ==============================
> Connor McDonald
>
> http://www.oracledba.co.uk
>
> "Some days you're the pigeon, some days you're the statue..."
Received on Tue Apr 23 2002 - 12:34:35 CDT