Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
LVM and VxVM
Showing results for 
Search instead for 
Did you mean: 

Online DB File System Defargmentation

Regular Advisor

Online DB File System Defargmentation



We run 24x7 Oracle & Progress databases and are considering using fsadm to regularly defrag the file systems.  Is there any user performance degradation or any other implication to running fsadm while the databases are open?


Will it be prudent to run them during quieter periods?


Thanks & Regards



Bill Hassell
Honored Contributor

Re: Online DB File System Defargmentation

It is very unusual for VxFS filesystems to require defrag. Unless you have some results that a defrag improves performance, I would never recommend defrag. Defrag can be fairly invasive as the rearrangement uses a careful series of steps to avoid data loss or corruption.  Oracle normally does not create, extend and remove massive numbers of files which is a typical way that fragmentation might occur. Progress is similar. Here's a Progress performance note:


Before deciding to defrag, run the defrag reports with fsadm -E and -D.

Bill Hassell, sysadmin