Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: separate data/inidex

Re: separate data/inidex

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Tue, 23 Apr 2002 17:34:35 GMT
Message-ID: <3CC59B1B.57B5715C@exesolutions.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US