Find Largest Tables in Oracle or SQL Server by Size (Volume)

Visual Expert can tell you what tables take up the most space in your Oracle or SQL Server database in terms of size (volume) of data.

How to Find the Largest Tables in your Database by Size of Data?

Visual Expert lets the developers sort the tables by size of data automatically.

  • Select the root of the tables in the treeview to make this feature available.
  • Click on ‘Table Size’ in the navigation bar.
    The tables will be listed with the size of data displayed in MBs beside them in descending order.

    Get largest tables by row count in Oracle & SQL Server database

  • To limit the number of tables displayed, click the ‘wrench’ icon to open the macro options window.

    Get largest tables by row count in Oracle & SQL Server database

  • For instance, this configuration will list the 10 largest tables in the database.

    Get largest tables by row count in Oracle & SQL Server database

SEE ALSO:

 

Visual Expert, Oracle, SQL Server, Find Largest Tables, Database Statistics