Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Defrag tool on the Oracle database server

Re: Defrag tool on the Oracle database server

From: Tim Gorman <tim_at_sagelogix.com>
Date: Fri, 06 Feb 2004 23:33:01 -0700
Message-ID: <BC49D4AD.FD5B%tim@sagelogix.com>


Defrag tools? On "real" servers we use RAID-0 -- on purpose -- to get things scattered all about in order to improve performance. And now the S/A wants to *ruin* all that?

...but in all seriousness, is this really necessary? Forgive me if I'm ignorant, but is there something in NTFS or whatever file-system Windows is using these days that is helped by defragging? Or is this something else that people do because ... well ... just because...

Database files don't strike me as ripe territory for a defragging problem, if it really is a problem. After all, databases don't create and drop database files on a frequent basis, and those files don't grow and shrink a whole lot.

on 2/6/04 1:46 PM, Freeman, Donald at dofreeman_at_state.pa.us wrote:

> I just asked this a little while ago. We were using a trial version of =
> diskkeeper at midnight for several months and it didn't hurt anything =
> but I think potentially it could if the database is active. The question =
> came up when we had to decide whether or not to buy it: What's going to =
> happen when Oracle and this thing start tusslin' over a file? We =
> stopped doing it.
>
> My data drives are badly fragmented now because we also stored backups =
> in the unused space and add and delete them all the time. We are moving =
> to a SAN in the next couple of months so we are leaving well enough =
> alone and in the future will make sure that the drives I have data on =
> only have Oracle files. I think Oracle can manage its own files well =
> enough to avoid fragmentation.=20
>
> If you want to try this I would take the database down first. I would =
> think that would be relatively safe. I believe there is some stuff on =
> this on metalink. Oracle, of course, is not going to give you anything =
> like an 'OK' for you to do this. I think what they said was that there =
> isn't any need to do defrag from an Oracle standpoint.
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Michael Fontana
> Sent: Friday, February 06, 2004 3:35 PM
> To: oracle-l_at_freelists.org; ORACLE-L_at_fatcity.com
> Subject: RE: Defrag tool on the Oracle database server
>
>
> I think this depends upon whether you really like this guy or not.
>
> If you do, research to see whether or not it will affect Oracle (I'd bet
> it will, and it will not be a good thing).
>
> If you don't like him, tell him to go right ahead, and don't research it
> at all....
>
>
> Michael Fontana
> Sr. DBA
> NTT/Verio
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
> Luc.Demanche_at_astrazeneca.com
> Sent: Friday, February 06, 2004 2:17 PM
> To: ORACLE-L_at_fatcity.com; oracle-l_at_freelists.org
> Subject: Defrag tool on the Oracle database server
>
>
> Hi DBAs,
>
> My sysadmin asked me if he can use a tool called Diskeeper to defrag the
> disks on our Windows servers.
>
> Did someone know that tool?
>
> What could be the impact on the Oracle datafiles?
>
> Thank you and have a good week-end ...
>
> Luc
>
> ---------
> Luc Demanche
> AstraZeneca R&D Montreal
> Oracle Database Administrator
> 514.832.3200 x2356
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------



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 Sat Feb 07 2004 - 00:33:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US