Re: Adding datafiles hang my server

Chris wrote:

> Freeze until the creation has finish,
>
> The time it take to create is OK (8 to 10 min.)
> i'm creating it via system user
> other users are suppose to be able
> to connect to db while i'm adding the datafile
> but all connection are stopped ...
>
> I'm creating 2 gbs datafile
> on a path that already exist
>
> i'm on a hardware raid 5
>
> ...
> thanks
>
> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1070498841.376565_at_yasure>...
>

>>Chris wrote:
>>
>>
>>>Hi,
>>>
>>>When i'm adding datafiles, my server hang
>>>all the connections are stopped or freeze ...
>>>but my cpu is only running at 4 %
>>>
>>>I'm running Oracle 9.2.0.1.0 on a win2K box
>>>
>>>Any helps will be appreciated
>>>
>>>Thanks
>>>Chris
>>
>>Freezes for how long? What size datafile? Does the desired path exist? 
>>Do you have write permission on it?
>>
>>Creating a large datafile can take a substantial amount of time while 
>>Oracle creates all of the blocks and does all of its mapping.
>>
>>We need more information to determine whether it really is freezing or 
>>you are just impatient.

8 - 10 minutes is incredibly long for 2GB to write. I'd have my adpater checked - I've seen RAID-5 adapters with a throughput worse that a 486 with an RLL disk! After replaceing the adpater things were back to normal (but RAID-5 does have a write penalty!)

-- 
Regards, Frank van Bortel