Re: DBMS_SPACE.CREATE_TABLE_COST

Posted by ErmanArslansOracleBlog on Nov 05, 2018; 8:36am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/DBMS-SPACE-CREATE-TABLE-COST-tp6907p6916.html

You want the math, huh? :)

FACT:

In 12C

The storage_clause is interpreted differently for locally managed tablespaces. For locally managed tablespaces, Oracle Database uses INITIAL, NEXT, PCTINCREASE, and MINEXTENTS to compute how many extents are allocated when the object is first created. After object creation, these parameters are ignored.

The recommendation is to set it 0, bytheway.

So whay don'tu you set it to 0 and make a test?