RE: having multiple datafiles per tablespace vs. one datafile per

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Sat, 16 Sep 2000 07:02:43 +1000
Message-Id: <10620.117172@fatcity.com>

Hi Doris,

The ability to add multiple datafiles concurrently was added in version 7.1.4 in response to bug 210833.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

@ Going to OpenWorld?
@ Catch the Ixora performance tuning seminar too!
@ See http://www.ixora.com.au/seminars/ for details.

-----Original Message-----
From: ddorr.cs_at_clearstream.com [mailto:ddorr.cs_at_clearstream.com] Sent: Saturday, 16 September 2000 0:56
To: Multiple recipients of list ORACLE-L Subject: RE: having multiple datafiles per tablespace vs. one datafile per

Hummm : I was under the impression ( not to say I was almost sure ) after some testing that if you have an ALTER TABLESPACE ADD DATAFILE running in one session, and you perform another one elsewhere, it will wait for the first one to complete before starting ...

The workaround was to add small datafiles, and then resize them, which could be done in parallel.

But I may be wrong ..... as it often happens :-) Received on Fri Sep 15 2000 - 16:02:43 CDT