a plsql utility for easily determining table sizes. The data returned includes table data size, index size, and lob size. Each value is returned individually, and also summed to provide a total table size. Figured are reported in MB and GB.

To run, first create the types and then the package.

This currently works for the current user, I'm going to modify it to accept a schema as input and point the references to all_tables/all_segments/all_indexes/all_lobs instead of the user views.

to execute, run

select from table(table_info_pkg.table_info(table_name)); where table_name is a string.

example:

select from table(table_info_pkg.table_info('CLAIMS'));