How To Determine Data Size Of A Table

to find actual size of a table:
select count (distinct substr(rowid,1,15)) from schema.table_name

explanation:
each rowid references a block. Sum of all the distinct blocks give you the actual table size.

HTH

so hows is a COUNT = to a SUM

you query wil return the number of rows

Quote:

---

Originally Posted by newbie

to find actual size of a table:
select count (distinct substr(rowid,1,15)) from schema.table_name

explanation:
each rowid references a block. Sum of all the distinct blocks give you the actual table size.

HTH

---

Migrated and chained rows?

Quote:

---

Originally Posted by slimdave

Migrated and chained rows?

---

The method I presented is the table size in Oracle blocks -- that would exclude all empty blocks below the HWM. IMHO, I would consider any block that contains the pointer or the actual migrated/chained rows as non-empty data blocks.

Quote:

---

Originally Posted by davey23uk

so hows is a COUNT = to a SUM

you query wil return the number of rows?

---

Sorry for my poor usage. SUM in this context is the result of the query presented not the function SUM in oracle.