Re: Adding datafiles hang my server

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.
Received on Thu Dec 04 2003 - 07:34:42 CST