select count (distinct dbms_rowid.rowid_block_number(rowid)) "used blocks" fromMultiply the result by your db block size to get the number of bytes required.
You can code a PL/SQL block to construct and execute dynamic SQL for each table of interest, summing the results as each table is queried.
Dig deeper on Using Oracle PL-SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.