CODEWITHSUNDEEP
sqloracle-databaseplsql
user3790762
user3790762

Reputation: 1

How to determine the size of a table occupied by a set or records/rows in oracle

I have a requirement to find the size/space occupied in a table by the result set of a query (few rows returned by the query).

Example: the table has 1000 records but the select query returns 150 records. I'm basically interested in knowing the space occupied by those 150 records in the table. How do I find out?

Thanks for your help.

Upvotes: 0

Views: 97

Answers (1)

OldProgrammer
OldProgrammer

Reputation: 12169

This is by no means exact, but you can get the average of a row, and use that in your calculation.

select AVG_ROW_LEN
from user_tables
where table_name = <whatever>

Upvotes: 1

Related Questions