Re: Adding datafiles hang my server

Sorry, is 2-3 min.
i'd check at the good place.

I'll try to change my Raid adapter
i thing is the problem

Frank <fbortel_at_nescape.net> wrote in message news:<bqo445$vmt$1_at_news1.tilbu1.nb.home.nl>...
> 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!)
Received on Fri Dec 05 2003 - 06:21:32 CST