Teradata : Get databases size in GB
Databases size in GB The size of database is the diffrence of maxperm and currentperm space of a database. select the sum of maxperm and currentperm from DBC.DISKSPACE and convert into GB and get the difference. Below is the query to find database size in GB select databasename,cast(sum(maxperm)/1024 ** 3 as decimal(7,2)) max_perm_GB, cast(sum(currentperm)/1024 **3 … More Teradata : Get databases size in GB