Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table size(Mb), row count, and index size(Mb) per each table

Toni JuniorNov 22 2019 — edited Nov 22 2019

Hello ,

is it possible to achive  that in one query , by select info for owned objects through schema system tables , user_tables, user_segments, user_indexes...

So the query could return  :  Table_name, row_count, table_size, index_size ? 

Comments
Post Details
Added on Nov 22 2019
7 comments
5,054 views