Re: Online DB File System Defargmentation (72 Views)
Reply
Regular Advisor
EU-Admins-UNIX
Posts: 196
Registered: ‎09-23-2011
Message 1 of 2 (88 Views)

Online DB File System Defargmentation

Hi

 

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

 

Tariq

Please use plain text.
Honored Contributor
Bill Hassell
Posts: 14,200
Registered: ‎05-29-2000
Message 2 of 2 (72 Views)

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:

 

http://knowledgebase.progress.com/articles/Article/P8479

 

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

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation