Extent sizes when using LMT with autoallocate clause

From: Daiminger, Helmut <Helmut.Daiminger_at_KirchGruppe.de>
Date: Tue, 03 Dec 2002 08:03:57 -0800
Message-ID: <F001.00510D94.20021203080357@fatcity.com>

Hi!

I was wondering what the allocated extent sizes for locally managed tablespaces with the autoallocate clause are? The first extents are 64k in size. How many 64k chunks are allocated? What are the next sizes?

CREATE TABLESPACE local_auto
DATAFILE '/u02/oradata/local_auto01.dbf' SIZE 1M reuse
EXTENT MANAGEMENT LOCAL AUTOALLOCATE; This is 9.2.0.2 on Solaris.

Thanks,
Helmut

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Daiminger, Helmut
  INET: Helmut.Daiminger_at_KirchGruppe.de

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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). Received on Tue Dec 03 2002 - 10:03:57 CST