| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Defrag tool on the Oracle database server
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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |