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

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Fri, 09 Mar 2001 18:28:02 -0800
Message-ID: <F001.002C8DDC.20010309174025@fatcity.com>

IMHO, the disk toolsuite that is unbeatable is by O&O Defrag.

something like oodefrag.com....

i have been using this to great effect for years.

and

they have some truly and really neat optimization utilities....

NT users will like this site.....

hth!

-----Original Message-----
From: Eric D. Pierce
To: Multiple recipients of list ORACLE-L Sent: 3/9/2001 4:35 PM
Subject: (Fwd) RE: (Fwd/Oracle) Does NT write to random locations on di

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 - 20:28:02 CST