RE: Defrag tool on the Oracle database server
- From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 6 Feb 2004 15:46:43 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Michael Fontana
Sent: Friday, February 06, 2004 3:35 PM
To: oracle-l@xxxxxxxxxxxxx; ORACLE-L@xxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Luc.Demanche@xxxxxxxxxxxxxxx
Sent: Friday, February 06, 2004 2:17 PM
To: ORACLE-L@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
