Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> create large tablespace q.

create large tablespace q.

From: <Lisa_Koivu_at_gelco.com>
Date: Thu, 25 May 2000 07:16:08 -0500
Message-Id: <10508.106654@fatcity.com>


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 Received on Thu May 25 2000 - 07:16:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US