Current Position:Home > Defragmentation at OS level

Defragmentation at OS level

Update:11-30Source: network consolidation
Advertisement
hii,
we use Oracle 8i on WIN NT 4.5 ,if i do defragmentation of HDD at OS level will there be any effect on databse .please advice.

The Best Answer

Advertisement
This is one of those operations that almost certainly has no upside and could certainly have a major downside.
First off, I would find it unlikely that Oracle database files are highly fragmented at the OS level. Generally, database files are allocated in chunks of hundreds of MB or GB-- fragmentation generally happens when you have lots of operations which cause files to grow and shrink, which is not what you see with Oracle.
In theory, if the database is shut down while the OS defrag utility is run, you should not damage your database. Realistically, though, given the negligible benefit, the potential cost is way, way too high.
Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
  • Defragmentation at OS level Update:11-30

    hii, we use Oracle 8i on WIN NT 4.5 ,if i do defragmentation of HDD at OS level will there be any effect on databse .please advice.This is one of those operations that almost certainly has no upside and could certainly have a major downside. First of

  • Defragmentation on system level Update:11-30

    Do as in the DB I have no defragmentation, So at the operating system will not have defragmentation?. Are the blocks in the extent always arranged in the same place the disk and in sequential order? Is when Oracle allocate new extents they always arr

  • What is database re indexing Update:11-30

    hi what  is database re indexing what is the concept of it, adilOne can REBUILD or REORGANIZE an existing index.   BOL: "This topic describes how to reorganize or rebuild a fragmented index in SQL Server 2012 by using SQL Server Management Studio or

  • A lot of time is taking to save the level 0 Data Update:10-11

    Hi Guys We have finanace cubes ,it has 34gig data in that ,every time when we do a maintenance we create some new members and delete some members ,move and so on ...etc when i save level 0 data it is taking a one to two hrs to save the outline . Even

  • Defragmentation in 10g Update:11-30

    hi friends, Database: 10.2.0.3 OS: windows 2003 server i had a tablespace (locally managed and segment space management auto) which is set as default for a user. few days back data was loaded into the tables for which i increased datafile size. yeste

  • Decimals mismatch after all data defragmentation Update:11-30

    Hi, We did a defragmentation of essbase cubes by exporting, clearing and import all data. There is a difference in decimals. Just to avoid the aggregation of cubes, we did a full data export rather than going for a level 0 and aggregation. Is there a

  • Cluster ratio & Defragmentation Update:11-30

    Scenario: Before:-Cluster ratio:1, Index cache=300MB After:- After running a calc scipt (max calc dim are used) cluster ratio-0.68 & index cache has increased. I am running the calc script as a part of test and I am not loading any data. Data is aggr

  • Hyperion User Acces and Defragmentation Update:11-30

    1.How to create  new user in share services and how to assign groups after that what is process will do hyperion planning 11.1.2.1 Verion,Please send me if you have any screen shots 2.What is the Defragmentation process steps in hyperion.Actually I e

  • REFS, lost hard disk space after Windows defragmentation Update:11-30

    Hi, first some short information about the Server. Windows Server 2012 Datacenter OS disk = 60 GB SSD Physical raid Controller: Areca ARC-1261 Raid  = Level 6 Used Disks = 11 x 2TB + 1 hot spare File system = REFS Usable space = 16,3 TB Real used spa

  • MAC OS extended journaled hard drive: does it need defragmentation? Update:11-30

    Hi, i have a 2TB external hard drive (A) upon which i have 1.5TB  of image and video files I am goimg to be seperating out the video files (approx 1Tb)  and transferring them to another hard drive (B) leaving lots of little gaps across this drive whe