Re: Resizing of Data Files - How Long SHOULD It Take?

From: Sean <smckeown_at_earthlink.net>
Date: Thu, 30 May 2002 00:09:08 GMT
Message-ID: <3CF56D74.11AD23DB@earthlink.net>

Richard E Sgrignoli wrote:
>
> Went back through the Oracle Change Control Log and came up with those figures.
>
> Yes, these were all INCREASES.....
>
> Example 1 was increased from 1650m to 1750m (increase of 100m)
>
> Example 2 was increased from 1750m to 1800m (increase of 50m)
>
> Example 3 was increased from 2200m to 2400m (increase of 200m)

Why don't you do a test and just see how long it takes the OS to create an empty file, say 500 MB, filled w/zeros on these same 3 filesystems? Use mkfile or something similar. If you see the same differences in timing, you can rule out Oracle as the culprit. If you don't see any differences, try another experiement - add a datafile instead of growing it. See if there's a noticable difference there. Might help debug the issue.

Regards,
Sean Received on Wed May 29 2002 - 19:09:08 CDT