RE: Extent sizes when using LMT with autoallocate clause

[Fink, Dan]

Title: Extent sizes when using LMT with autoallocate clause

From memory...

16 extents of 64K = 1 meg

63 extents of 1m = 63 meg (64 total)

120  extents of 8m = 960 meg (1024 meg or 1 gig total)

Additional extents are 64m (I never found an upward bound in testing...) *This is undocumented by Oracle (last I checked)

 

Dan Fink

-----Original Message-----
From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 9:04 AM
To: Multiple recipients of list ORACLE-L
Subject: Extent sizes when using LMT with autoallocate clause

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