Archives of the TeradataForum
Message Posted: Mon, 16 Nov 2015 @ 14:32:10 GMT
Below query can help you to find the total allocated space and consumed space and free space by database level.
select databasename, sum(maxperm) totperm, sum(currentperm) totused, sum(maxperm) - sum(currentperm) available from dbc.diskspace group by databasename having totperm > 10.0 order by 1;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|