How to determine the size of the APM database (APMDB) and the size of the largest tables?

Description:

It is good practice to perform database maintenance on a monthly basis. This includes checking the size of the APM database (APMDB) tables.

Solution:

There are a variety of links on this topic.

• For Postgres
• http://wiki.postgresql.org/wiki/Disk_Usage
• http://stackoverflow.com/questions/10006294/simplify-an-postgres-sql-query-for-listing-table-and-index-sizes
• For Oracle
• http://www.dba-oracle.com/t_script_oracle_table_size.htm