calculate sizing of a table

Posted by Roshan on Oct 08, 2018; 6:46am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/calculate-sizing-of-a-table-tp6824.html

Oracle Database 12.2.0
RHEL 7.4

Hi Erman,

I am loading data from flat files once per day. I am querying dba_segments to get the segment bytes. Is this value sufficient to calculate the table size? or should I take into account
colkumn overhead, row overhead, block overhead and PCTFREE , plus a couple of oddities with longs, lobs and strings longer than 254 bytes

Regards,

Roshan