Tech Diary
September 5, 2014
Teradata database storage space computation
SELECT
SUM(CurrentPerm)/(1024*1024*1024) (DECIMAL(15,6)) (TITLE 'Current Perm size in GB') ,
SUM(MaxPerm)/(1024*1024*1024) (DECIMAL(15,6)) (TITLE 'Max Perm size in GB')
FROM dbc.DiskSpace WHERE DatabaseName='a_database';
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment