Re: create large tablespace q.

Based on the a couple large datafiles I recently created, the length of time sounds about right. As far as what's going on in the background, I am interested in hearing from the experts as well.

Lisa_Koivu_at_gelco.com wrote:

> My large db that I hosed yesterday has 6 properly sized tablespaces - ~8GB each.
> We are using Veritas quick i/o on Solaris 2.6, E10000 domain.
> Still, one create tablespace statement, with all 4 2GB datafiles in the datafile
> clause with reuse, takes about 15 minutes.
> This is no wimp machine and right now it's at my disposal.
>
> Does creating a tablespace with large datafiles always take this long? I'm
> curious what Oracle is doing in the background - is it formatting the blocks to
> it's liking? Scanning everything? Any insights are appreciated.
>
> Thanks
> Lisa
>

--
__________________________________________________________________
Dwayne Cox                                   University of Florida
Senior Systems Programmer                    College of Engineering
dcox_at_eng.ufl.edu                             521 Weil Hall
352.392.9217                                 Gainesville, FL  32611
___________________________________________________________________
The opinions expressed are the author's own unless otherwise stated