RE: create large tablespace q.

Hi Lisa,

Yes, Oracle formats all the blocks.

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/


-----Original Message-----
From:	Lisa_Koivu_at_gelco.com [SMTP:Lisa_Koivu_at_gelco.com]
Sent:	Thursday, May 25, 2000 11:38 PM
To:	Multiple recipients of list ORACLE-L
Subject:	create large tablespace q.

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

-- 
Author: 
  INET: Lisa_Koivu_at_gelco.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).