[ale] why would it take longer to delete a file than to createit?

[Brian Pitts]

On 05/06/2010 11:39 AM, Greg Freemyer wrote:
> John,
> 
> As a general statement, taking 3 minutes to create a 1GB file on an
> active db server is not that slow.
> 
> I would not at all assume something is wrong based on that one test.
> 
> How many i/o's per second are you seeing with just db activity?
> 
> (iostat -d 1      is how I check that).
> 

Seconding the use of sysstat. Look at 'sar -b' and 'sar -d'.

You may have to edit the systat cronjob to get it to record statistics
necessary to use -d with sar.

http://pagesperso-orange.fr/sebastien.godard/man_sar.html

-- 
All the best,
Brian Pitts