Re: DBMS_SPACE.CREATE_TABLE_COST

Posted by Roshan on Nov 01, 2018; 3:22pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/DBMS-SPACE-CREATE-TABLE-COST-tp6907p6914.html

Hi,

thanks. In fact this was what I wanted to know. The DATE data which is stored in fixed length format.

As for the pct increase in the function below

DBMS_SPACE.CREATE_TABLE_COST('BIREPORT',cl,10,10,ub,ab);

could you please advise how do I calculate the pct increase for the table?

Suppose the data increase between this month and last month is 100GB, would the pct increase be 100GB/last month *100?