Usage of space on HDDs

SELECT SUM(extent_count)*3/1024/1024 total_disk_space_tbytes,
SUM(extents_used)*3/1024/1024 allocated_disk_space_tbytes,
(SUM(extent_count) – SUM(extents_used))*3/1024/1024 free_disk_space_tbytes,
SUM(extents_used)/SUM(extent_count)*100 allocated_disk_space_prcnt,
100 – SUM(extents_used)/SUM(extent_count)*100 free_disk_space_prcnt,

MIN(extents_used*1.0/extent_count)*100 spu_storage_utilization_min,
AVG(extents_used*1.0/extent_count)*100 spu_storage_utilization_avg,
MAX(extents_used*1.0/extent_count)*100 spu_storage_utilization_max

FROM _vt_disk_partition
WHERE isprimary;
SELECT dsid,
SUM(extent_count)*3/1024 total_disk_space_gbytes,
SUM(extents_used)*3/1024 allocated_disk_space_gbytes,
(SUM(extent_count) – SUM(extents_used))*3/1024 free_disk_space_gbytes,
SUM(extents_used)/SUM(extent_count)*100 allocated_disk_space_prcnt,
100 – SUM(extents_used)/SUM(extent_count)*100 free_disk_space_prcnt
FROM _vt_disk_partition
WHERE isprimary
GROUP BY dsid
ORDER BY SUM(extents_used) DESC
SELECT SUM(used_bytes)/1024/1024/1024/1024 used_bytes_tbytes,
SUM(allocated_bytes)/1024/1024/1024/1024 allocated_tbytes
FROM _v_sys_object_storage_size;
SELECT sod.objid,
sod.objclass,
sod.objowner objownerusesysid,
sod.owner objownerusername,
sod.objname,
sod.createdate,
sod.objtype,
d.objid dbobjid,
sod.dbname,
d.dbowner dbownerusesysid,
d.owner dbownerusername,
d.createdate dbcreatedate,
soss.used_bytes,
soss.block_size,
soss.allocated_blocks,
soss.allocated_bytes,
soss.allocated_bytes,
soss.allocated_avg,
soss.used_blocks,
soss.used_bytes,
soss.used_min,
soss.used_max,
soss.used_avg,
soss.used_spread,
soss.skew,
soss.parentid,
soss.sorted_bytes,
soss.sorted_blocks
FROM _v_sys_object_data sod
INNER JOIN _v_sys_object_storage_size soss ON sod.objid = soss.tblid
AND sod.objtype <> UPPER(‘TEMP TABLE’)
INNER JOIN _v_sys_database d ON sod.dbname = d.objname;