Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Does NT write to random locations on disk?

RE: Does NT write to random locations on disk?

From: Kevin Kostyszyn <kevin_at_dulcian.com>
Date: Fri, 09 Mar 2001 13:41:31 -0800
Message-ID: <F001.002C8AF3.20010309123121@fatcity.com>

I
would have to agree, it is not going to actually defrag the datafile itself.  NT defrag is not taking apart files and putting them back together, it moves files around.  It is going to consider the db file one big file, it might not do anything at all to defrag. <FONT face=Arial color=#0000ff
size=2>Kev

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Jacques KilchoerSent:   Friday, March 09, 2001 3:06 PMTo: Multiple recipients of list   ORACLE-LSubject: RE: Does NT write to random locations on   disk?
> -----Original Message----- >

  From: Smith, Ron L. [<A
  href="mailto:rlsmith_at_kmg.com">mailto:rlsmith_at_kmg.com] <FONT   size=2>> Sent: vendredi, 9. mars 2001 11:36 >
> I wouldn't think you would want to reorg an
  Oracle tablespace > with an NT <FONT
  size=2>> defrag utility.  You would corrupt the data.   Forgive my ignorance, but in a datafile on a file-system-based   disk, doesn't Oracle go through the OS to access the files on disk? Why would   an NT defrag utility cause a problem? I think I'll go try it myself on a test   database this week-end (time permitting). Received on Fri Mar 09 2001 - 15:41:31 CST

Original text of this message

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