Oracle: How to convert row count into data size

Question

I would like to know how do i convert number of row into size like in MB or KB? Is there a way to do that or formula?

The reason I doing this is because I would like to know given this set of data but not all in tablespace, how much size is used by this set of data.

Thanks, keith

user330315 · Accepted Answer · 2016-07-13 07:35:28Z

1

If you want an estimate, you could multiple the row count with the information from user_table.avg_row_len for that table.

If you want the real size of the table on disk, this is available user_segments.bytes. Note that the smallest unit Oracle will use is a block. So even for an empty table, you will see a value that is bigger tzen zero in that column. That is actual size of the space reserved in the tablespace for that table.

answered Jul 13, 2016 at 7:35

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle: How to convert row count into data size

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related