which tool can report size of every table

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

# proutil dbname -C dbanalys > dbanays.dbname
 
in order to reduce the db size,need to know which tables increase fatser.
Click to expand...

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.
 
You must log in or register to reply here.
Back
Top