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

From: Sean M <smckeownNO_at_BACKSIESearthlink.net>
Date: Thu, 30 May 2002 11:19:02 -0600
Message-ID: <3CF65F06.FCB4A4E2@BACKSIESearthlink.net>

Richard E Sgrignoli wrote:
>
> 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)

But which filesystem did you do these tests on? These results are really not very helpful unless you can compare them amongst *all* three filesystems in question. The idea is to see if the filesystem that takes a lot longer to extend an Oracle datafile *also* takes a lot longer to simply create a large empty file, in which case you could reasonably rule out Oracle as the problem.

Regards,
Sean Received on Thu May 30 2002 - 12:19:02 CDT