Re: Adding datafiles hang my server

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.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)