(Fwd) RE: (Fwd/Oracle) Does NT write to random locations on di

From: Eric D. Pierce <PierceED_at_csus.edu>
Date: Fri, 09 Mar 2001 14:12:16 -0800
Message-ID: <F001.002C8BB1.20010309133543@fatcity.com>

Apparently the preferred defragger is Norton Utilities:

http://enterprisesecurity.symantec.com/content/productlink.cfm

(Symantec Speed Disk 5.1 for Windows NT Info ):

http://enterprisesecurity.symantec.com/products/products.cfm?ProductID=8&PID=3133528

(warning: above URL may wrap)

Forwarded message follows ------- To: "'PierceED_at_csus.edu'" <PierceED_at_csus.edu>, WINNT-L_at_PEACH.EASE.LSOFT.COM Date sent: Fri, 9 Mar 2001 14:21:03 -0600

I'm pretty sure ABs preferrence is for SpeedDisk and if so, I'd have to agree. :)

-----Original Message-----
Sent: Friday, March 09, 2001 2:19 PM
To: WINNT-L_at_PEACH.EASE.LSOFT.COM

Mike,

Yes, I remember seeing discussion of the need for defragging NT/Win2k servers (and AB's preference for Diskkeeper?).

http://www.diskeeper.com/diskeeper/diskeeper.asp

I'm guessing the Oracle DBAs are still curious about the underlying I/O architectural issues involved.

regards,
ep

(cc: via separate fwd to Oracle-L)

On 9 Mar 2001, at 12:00, Mike Soultanian <msoultan_at_csulb.edu> wrote:

Date sent:              Fri, 09 Mar 2001 12:00:50 -0800
To:                     PierceED_at_csus.edu
Copies to:              WINNT-L_at_PEACH.EASE.LSOFT.COM

locations on disk?

> I don't know the answer to your question, but if you didn't already
> know, there is diskeeper for NT. Plus, they have a frag guard thing
> that will defrag on the fly, or something like that. I haven't tried
> it, I just get their newsletter all the time :)
>
> Later,
> mike
>
> "Eric D. Pierce" wrote:
> >
> > ------- Forwarded message follows -------
> > Date sent: Fri, 09 Mar 2001 11:00:31 -0800
> > To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
> > From: "Boivin, Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca>
> > Subject: Does NT write to random locations on disk?
> >
> > 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?

...

The WINNT-L list is hosted on a Windows NT(TM) machine running L-Soft international's LISTSERV(R) software. For subscription/signoff info and archives, see http://peach.ease.lsoft.com/archives/winnt-l.html . ------- End of forwarded message -------

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: PierceED_at_csus.edu

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

Received on Fri Mar 09 2001 - 16:12:16 CST