Re: Adding datafiles hang my server

Are these disks SCSI or IDE? IIRC, IDE disks were never built to handle simultaneous requests. So your I/O request to allocate a datafile stops other I/O requests from occurring. If the database needs an I/O request, it must wait for the first one to complete.

Cheers,
Brian

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

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"