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: Fragmented vs. Contiguous vs. Single-extent segments

Re: Fragmented vs. Contiguous vs. Single-extent segments

From: Steve Long <steven.long_at_erols.com>
Date: Sat, 14 Apr 2001 12:45:52 -0400
Message-ID: <9b9v0r$maj$1@bob.news.rcn.net>

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

Original text of this message

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