Use this to find out how much perm space the tables in a specific database are using in megabytes:
SELECT tablename,SUM(currentperm)/1024/1024 MB FROM dbc.allspace WHERE databasename='your_database_name' GROUP BY 1 ORDER BY 2 DESC; |
Tags: TeradataTip