Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: Fragmentation query
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
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
yong321_at_yahoo.com
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 :)
-- Author: yong huang INET: yong321_at_yahoo.com 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Fri Sep 15 2000 - 11:17:54 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |