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

I did a mkfile as you suggested within the same filesystem with the various sizes; the results were:

     mkfile 50m test1 (took 2.61 seconds)

     mkfile 100m test2 (took 4.21 seconds)

     mkfile 200m test3 (took 7.59 seconds)

Sean <smckeown_at_earthlink.net> wrote in message news:<3CF56D74.11AD23DB_at_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 Thu May 30 2002 - 11:46:41 CDT