Using a little utility called contig I noticed that the Oracle 8.1.6
datafiles on my test NT server are quite fragmented, an average of 177
fragments per file, 118 fragments for the OEM repository datafile. The poor
utility couldn't do anything with the database files, they are too large
perhaps.
These were created on an empty server, 8i release 2 went on it after a
defrag, then the OEM. This is on a hard disk with 1.2G of free space, none
of the datafiles come close to that.
Why so many fragments? Oracle created those files in one pass, does NT
write randomly to disk or what?
Won't this have an impact on my NT database's performance?
Oracle says tablespace fragmentation is not a big deal, but fragmentation at
the OS level matters. Supposedly that's why NT and WndowsXX came with
defragmentation tools.
???
Is there a registry setting somewhere to tell NT to write contiguously to
disk?
TIA
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services | Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO | Région des Maritimes, MPO
E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
