Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

Creating a BIGFILE tablespace -- "optimal" NEXT size?

edited Jan 3, 2018 4:36PM in Storage Management (ASM ACFS DNFS ODM) (MOSC) 3 commentsAnswered ✓

For BIGFILE tablespaces -- does "one (NEXT) size fit all"?

create bigfile tablespace big_ext

   datafile '+data'

  size 1g autoextend on next 4g maxsize 32t

  extent management local autoallocate;

 

Let's say that the tablespace already has 24 TB allocated, therefore it has extended over 5000 times. For another tablespace, I do this:

create bigfile tablespace big_ext2

  datafile '+data'

  size 16g autoextend on next 32g maxsize 32t

  extent management local autoallocate;

Once the space is allocated for the tablespace in the disk group, is there any additional overhead when allocating new segments in the tablespace? Or accessing existing segments? Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center