Fragmentation query

From: O'Neill, Sean <Sean.ONeill_at_organon.ie>
Date: Thu, 14 Sep 2000 16:26:51 +0200
Message-Id: <10619.116974@fatcity.com>

Hi Folks,

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 :)

######   ######  ######  ###### 
#    #   #    #  #    #  #    #  Rookie
####     #    #  ######  ######  Data
#   #    #    #  #    #  #    #  Base 
#    #  #######  ######  #    #  Adminstrator
-------------------------------- ------------ 

Organon (Ireland) Ltd.
E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]

The only man who never makes a mistake is the man who never does anything.

• Theodore Roosevelt

Received on Thu Sep 14 2000 - 09:26:51 CDT