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

One thing I just noticed about this system which differs with the other domains is the fact that the system in question (deemed slow by Oracle during resizes) has some VERY HUGE filesystems. Whereas most the Oracle filesystems on the domains are in the 14Gb to 28Gb (per LUN) range, we show the "slow" domain having LUNs of 73Gb EACH. These are CONCATENATED vice STRIPED.

With this being said, could it be that the huge difference in LUN sizes (73Gb as opposed to 28Gb) will affect the timeliness of the resize increases?

Thanks.

Richard

Richard.Sgrignoli_at_highmark.com (Richard E Sgrignoli) wrote in message news:<9a3c69df.0205280519.3a101d52_at_posting.google.com>...
> I'm not an Oracle DBA, but am a UNIX (Solaris) Sys Admin.....recently,
> I have had a question come up from an Oracle DBA relating to time it
> took to resize a data file with an inference that there was a problem
> with a controller/disk on that particular server "because on other
> domains it would have taken SECONDS!"
>
> I do not know what all is involved with resizing a data file, but I
> will attempt to provide some data below which, hopefully, will allow
> someone to shed some light on what the norm is for resizing and how
> long it takes.
>
> Example 1:
> data file "p65.dbf"
> resized 1750m - took 1 minute 22 seconds
> current file size: 1,835,016,192 bytes
>
> Example 2:
> data file "23p.dbf"
> resized 1800m - took 45 seconds
> current file size: 2,097,160,192 bytes
>
> Example 3:
> data file "12p.dbf"
> resized 2400m - took 34 minutes 38 seconds
> current file size: 1,677,729,792 bytes
>
> As you can see, there is no firm correlation with larger resizes
> taking longer.
> In doing iostat comparisons between the disks involved in THESE
> resizes and those on other domains (which Oracle says takes "only
> SECONDS" to resize), I see no difference in service times or busy
> rates. I guess my main question here is: What are some other factors
> I should be considering in trying to come up with an explanation of
> why it is taking so long to resize? What is the norm time required to
> resize? I do not want to spin my wheels trying to come up with
> something that does not exist simply because our Oracle folks are TOO
> impatient, yet I want to be able to better investigate and fix a
> problem if, in fact, these times ARE too slow. Any feedback greatly
> appreciated.
>
> Richard
Received on Wed May 29 2002 - 15:03:48 CDT