How to find the space used by a particular database in Teradata?

24) How to find the space used by a particular database in Teradata?

Answer >

SEL DATABASENAME,TABLENAME,SUM(CURRENTPERM)/(1024*1024*1024)

FROM DBC.TABLESIZE

WHERE TABLENAME=’xxxxxxx’

GROUP BY 1,2;