Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: Fragmentation query

Re[2]: Fragmentation query

From: <>
Date: Fri, 15 Sep 2000 12:17:54 -0400
Message-Id: <>

If the Disk is fragmented, then there should be not only a performance slow down for Oracle, but other applications as well & yes defragamenting it will help. Oracle will not care since it is only keeping track of what is happening inside it's datafiles. Now having a fragmented Oracle object I don't see as a problem most of the time. The exception being a case where an object consists of lots of small extents such that part of a disk read is wasted. By that I mean that I would not get fussed by an object that consisted of 220 1M extents, but I might get upset by an object that consists of 100 8K extents.

Dick G.

____________________Reply Separator____________________
Subject: Re: Fragmentation query
Author: yong huang <>
Date: 9/15/00 8:36 AM

I see no relationship between these two fragmentations. If your disk is highly fragmented, your database tablespace (assuming you're talking about disk, not memory such as SGA, fragmentation) could still contain most extents contiguously. In this case, if you look at block_id and blocks of dba_extents order by block_id, you see most extents bumper to bumper, so to speak. Oracle knows nothing about the underlying OS fragmentation. On the other hand, if you defragment the disk (while the database is shutdown of course), all OS blocks are coalesced. But the Oracle extents could still contain the holes of empty extents.

Defragmenting the disk at OS level definitely helps IO scan. After all, Oracle has to move the hard drive spindle to do physical reads. Defragmenting
(coalescing) tablespaces in Oracle may or may not help physical reads as far as
I understand. It helps disk space usage though.

The above said is only relevant to cooked file systems.

Yong Huang

you wrote:

I'd like to try and understand the issues, if any, between fragmentation of a disk from operating system perspective vs fragmentation from Oracle's perspective. How, if at all are the two types of fragmentation connected?. Are there issues for Oracle if a disk defragmenter is used at OS level or is Oracle "insulated" from these changes. I'm thinking about a data file (OS level) which contains a tablespace with it's selection of tables, each of which is composed of extents etc. etc. and trying to piece it all together. Is the OS and Oracle talking at some level and exchanging information about what they've re-arranged?. I suspect I'm missing some thing obvious in above but would appreciate any help, white paper, manual references that may help clarify the above for me.

Sean :)

Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
Author: yong huang

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Sep 15 2000 - 11:17:54 CDT

Original text of this message