Determine the size of all the tables in an Oracle database schema
Finding the true size of tables in Oracle Database can be significantly more nuanced than in other relational database systems. Unlike PostgreSQL (with pg_total_relation_size) or MySQL, Oracle manages physical storage through a hierarchy of blocks, extents, and segments spread across tablespaces. If you simply query USER_TABLES or sum USER_SEGMENTS for segment_type = ‘TABLE’, you are… Read More: Determine the size of all the tables in an Oracle… »