Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Does NT write to random locations on disk?
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
![]() |
![]() |