DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Use of 'Diskeeper' to defrag NT blocks

  1. 03-25-2002, 07:41 AM #1
    JMac
    JMac is offline Red Boy of Differdange
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Doesn't sound 'safe' to me. Our Network Admin wants to use Diskeeper to defrag our NT4 Oracle server. I'm not convinced this won't do something disastrous to the 8i database - am I correct?
    Reply With Quote Reply With Quote
  2. 03-25-2002, 07:44 AM #2
    aarroyob
    aarroyob is offline Senior Advisor
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    In my opinion nothing will happend with Oracle. The reason to think this is this utility only "defrag" free space. The space for Oracle database, for SO is used, then ...

    Obviously, I will stop the database and services.

    It's only my opinion, I have never done.

    Regargs

    Angel
    Reply With Quote Reply With Quote
  3. 03-25-2002, 09:31 AM #3
    ovidius
    ovidius is offline Member
    Join Date
    Mar 2002
    Posts
    192
    In my oppinion, in certain situations it could do some improvement. This is when at the initial space allocation the space was very fragmented on disk, and now it will compact the fragments and make the oracle allocated space contiguous. But this is an unusual situation. You know, when you make the database you think to allocate as much as you will need, and you do not install a new important database on a already fragmented disk...
    It is obvious WHY is better to close the database before, but practically, there is no reason diskeeper put your data into any danger. But the database become almost unusable because of the disk overhead. And the operation take maybe ten times longer, and this increases the risk of being caught by any power failure in this time...
    So, if the disk isn't highly fragmented in "Oracle zone", there is no reason to do this. But if not, it is important to do it!
    More important seems to me to keep the data not fragmented FROM THE ORACLE POINT OF VIEW. That means the fragmentation of segments on a file, the migration of data in blocks etc. This could dramatically decrease the database performance, highlited when the system is very poor in phisical memory (related to the needs, I'm not talking about absolut values. For my database 256Mb for Oracle is enough, but for yours 4Gb could be poor )) ).
    So, do it, but do it periodically, at a large amount of time between. And seriously consider a rebuild of the entire database AFTER that.
    And then take a brake for 1 year (of course, depending of the database activity, in fact...), and do it again.
    BR,
    ovidius
    ovidius over!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width