which tool can report size of every table

[wzj90023]

in order to reduce the db size,need to know which tables increase fatser.

 

[SSuhaib]

We run dbanalys & tabanalys (rarely) to find the table size and growth once in every 3 months.

# proutil dbname -C dbanalys > dbanays.dbname

 

[Casper]

in order to reduce the db size,need to know which tables increase fatser.

reducing the db size is just contrary to what a database is designed for.

If you want to purge data from your database then I can't imagine that descissions on deleteing data can be based on measurement of growth and number of records.

Casper.