Re: Defrag tool on the Oracle database server

From: Tim Gorman <tim_at_sagelogix.com>
Date: Mon, 09 Feb 2004 07:44:09 -0700
Message-ID: <BC4CEAC9.FE9F%tim@sagelogix.com>

So, to repeat my original question: is there something about NTFS (or whatever file-system Windows is using) that is susceptible to this problem?

How is it that there are no "defrag" utilities for UNIX? And if there are, they are never utilized and the people who wrote/ported it are starving?

I've always considered "fragmentation" to be one of those joke responses to management queries. "Uh yeah, we're badly fragmented and the databits are not multiplexing properly through the parity groobfluffer"...

on 2/9/04 12:42 AM, Adrian Turner at adrian_at_astenconsultants.co.uk wrote:

> I can give you a reason for using disk fragmenting datafiles that I've
> encountered in the real world.
>
> We moved a 150GB data warehouse to a Win2K server running on an EVA SAN. The
> target server had 8 CPUs available so we unzipped the files concurrently 8
> ways parallel to increase deployment speed.
>
> When testing it was discovered performance was 20% slower on better disk
> hardware. Indeed the chosen example job was still full table scanning, but
> the 10046 showed the scattered read I/O rate was often much slower than the
> minimum. Pfiles etc were left the same as per the source server.
>
> After a lot of investigating of the new SAN, the SA reported the oracle
> datafiles were heavily fragmented. Because of running the multiple unzips
> the files had been fragmented into thousands of 512Kish chunks. An example
> 2K datafile had 4000+ fragments! So we defragged on the OS (with a shutdown
> db) and performance increased to better than the source system speed.
>
> HTH
>
> Adrian
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Paul Drake
> Sent: 09 February 2004 03:00
> To: oracle-l_at_freelists.org
> Subject: Re: Defrag tool on the Oracle database server
>
>
> --- Jared Still <jkstill_at_cybcon.com> wrote:

>> 
>> Paul,
>> 
>> Can you point us to, or share any good papers
>> on setting up this kind of security in a Windows
>> environment?
>> 
>> Setting this up is easy in *nix systems, but I
>> find myself somewhat challenged as to how to go
>> about it in the Windows world.
>> 
>> Jared

>
> Jared,
>
> do you mean in a useful paper form, as opposed to a
> powerpoint presentation? that presents a slight
> problem.
>
> the powerpoint presentation of "Nimda ate my
> Database!" that I was fortunate enough to be able to
> deliver at RMOUG 2003 is still available, but it was
> not very useful. It does cover filesystem permissions.
>
> I never did deliver the finished paper, just my notes
> to those that asked for them. That paper should have
> been writted and published on the RMOUG site (and the
> OOUG site).
>
> I'll see what I can dig up for you. Some of the w2k
> version is obsoleted by w2k3 server, but the
> principles still apply.
>
> If its for 9.2 / w2k Server I think that I can produce
> something rather quickly. Sounds like a good SANS
> paper topic. I'd like to become a *certified* bastard
> DBA from hell /BOFH in the near future.
>
> It wouldn't be an Oracle User group conference for me
> if I wasn't having to put together something for it a
> couple of days before. Plane ride Tuesday, that should
> provide some excellent writing time.
>
> The past year went by very quickly.
>
> Paul
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Finance: Get your refund fast by filing online.
> http://taxes.yahoo.com/filing.html
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
>
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Feb 09 2004 - 08:44:09 CST