Determining the Size of Oracle database tables and indexes
Useful views to get index details: dba_indexes dba_segments dba_ind_columns dba_ind_partitions user_indexes user_segments user_ind_columns user_ind_partitions Query to check Index on a Table in Oracle. Find the list of top index size corresponding to a table. Check Index Column on a Table in Oracle. Find total index size of respective tables in a schema. Find the list … Read more