Re: NEXT usage in CREATE TABLESPACE statement

On Oct 10, 4:57 pm, ora_quest..._at_yahoo.co.uk wrote:
> hi,
> i would like to ask how is the "NEXT" keyword in CREATE TABLESPACE
> EXTENT MANAGEMENT LOCAL AUTOALLOCATE statement used. i mean what does
> it specify? the size of the first extent?
> i know that in locally managed tablespaces with AUTOALLOCATE allocation
> type Oracle server calculates/determines the size of the extents. does
> this value specify a starter extent size?
>
> this question came into my mind after i have read that UNDO tablespaces
> should use EXTENT MANAGEMENT LOCAL AUTOALLOCATE and i saw the keyword
> NEXT in the UNDO tablespaces DDL. by now i thought the NEXT value
> specified a UNIFORM extent size with locally managed tablespaces.
>
> here is an example of such DDL:
>
> SQL> select dbms_metadata.get_ddl('TABLESPACE','UNDO') from dual;
>
> CREATE UNDO TABLESPACE "UNDO" DATAFILE
> 'some_datafile_name.dbf' SIZE 262144000 REUSE
> AUTOEXTEND ON NEXT 5242880 MAXSIZE UNLIMITED
> BLOCKSIZE 8192
> EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT MANUAL
>
> thanks for your answer in advance

As far as I know NEXT is a remnant from the dark past, and it is just ignored.
You could easily verify it by looking at the next extent of the various objects in your tablespace and the real extent sizes in dba_extents

-- 
Sybrand Bakker
Senior Oracle DBA