Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009
    Posts
    1

    Unanswered: Windows Defragmention...On Ordcle Drive

    Hi All,

    My sysadmin asked me if he can use a Windows default tool for defragmentation on Windows Server 2008. This Drives contains Oracle Database Files ( DBF's) .

    What could be the impact on the Oracle datafiles?

    If i can run the tool to defragment it, What should be my approach.

    Your immediate reponse will be appreciated.

    Many Thanks,
    Rizwan

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    This question leads to the ever popular answer: it depends.

    There are more than one Windows Defragmentation tool. There are differences in versions of Oracle. There are complications if you are using third party products like VM environments, SAN management, backup tools, etc.

    Another question that I'd ask would be "how much will defragmentation help database access?". If your sysadmin doesn't have a good solid answer, then I'd resist doing a defrag just because it sounds like a good idea... If there isn't a clear benefit, why risk it?

    The short answer is that when Oracle and the associated tools are down and not running in any way it is nearly always safe to defragment a drive. The more programs that might access the disk while the defragmentation is occurring, the higher the risk of database corruption.

    If the data is redundant or isn't especially valuable such as a staging database for a data warehouse or clickstream data which is rarely if ever needed, then you can probably get by defragging whenever you choose. If downtime is hard to schedule, you at least need to make a backup that you can take offline just before you defrag. If the data is really valuable, then I'd take a backup and then quiesce everything that I could that might access the disk before running the defrag.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •