Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Fragmented vs. Contiguous vs. Single-extent segments
how did you account for physical fragmentation on the disk vs the logical fragmentation in oracle?
"Paul Miller" <millerp_at_sql.org.uk> wrote in message
news:millerp-1404011039040001_at_192.168.0.2...
> In the recent debate at the oracledba_at_lazydba.com mailing list on
> locally/dictionary managed tablespaces, several suggestions were made
> about the loss of performance brought on by fragmentation. I have always
> wondered how great that loss of performance is.
>
> So I set up the experiment and ran the tests, and the results may be a
> little surprising. Instead of going into the detail on the list though, I
> have posted the initial results and a description of the experiment at:
>
> http://www.caribdata.co.uk/tech/frag.html
>
> Your comments are welcome.
>
> Regards
>
> Paul Miller
> --
> -
> Carib Data Limited
Received on Sat Apr 14 2001 - 11:45:52 CDT