Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How is the size of extents defined?

April 26, 2017defined extents size

0

Posted

How is the size of extents defined?

1 Answer

0

Posted

The size of the extent is determined in a different way depending on the tablespace type used: LMTS UNIFORM (Note 214995) When a tablespace is created, all extents have the standard defined extent size. This can be determined as follows: SELECT NEXT_EXTENT FROM DBA_TABLESPACES WHERE TABLESPACE_NAME = ‘‘; LMTS AUTOALLOCATE The extent sizes are determined using an internal algorithm (see Note 599694). Dictionary Managed Tablespace (previous standard) The sizes of the extent can be specified when you create the segments within the STORAGE clause. INITIAL determines the size of the first extent, while NEXT specifies the size of the next extent. In addition, PCTINCREASE must be set to 0 to prevent the extents from being increased in each case by a certain percentage. Example (creating a table with an extent size of 2 MB): CREATE TABLE … STORAGE (INITIAL 2M NEXT 2M PCTINCREASE 0); The current storage parameters of a segment can be determined using the following query: SELECT IN