Database objects 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_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_database d
LEFT JOIN _v_sys_object_data sod ON d.objname = sod.dbname
LEFT JOIN _v_sys_object_storage_size soss ON sod.objid = soss.tblid
WHERE sod.objtype IN (‘TABLE’, ‘MATERIALIZED VIEW’, ‘MVIEW_STORE’)
AND sod.dbname = ‘MY_DB_UTILS’;
SELECT sod.dbname,
sod.owner objownerusername,
sod.objname,
sod.createdate,
sod.objtype,
soss.used_bytes/1024/1024/1024 used_gbytes,
soss.skew
FROM _v_sys_database d
LEFT JOIN _v_sys_object_data sod ON d.objname = sod.dbname
LEFT JOIN _v_sys_object_storage_size soss ON sod.objid = soss.tblid
WHERE sod.objtype IN (‘TABLE’, ‘MATERIALIZED VIEW’, ‘MVIEW_STORE’)
AND sod.dbname = ‘MY_DB_UTILS’;
SELECT sod.dbname,
sod.owner objownerusername,
sod.objname,
sod.createdate,
sod.objtype,
soss.used_bytes/1024/1024/1024 used_gbytes,
soss.skew,
SUM(soss.used_bytes)OVER(PARTITION BY sod.dbname, sod.owner) used_bytes_by_db_and_user
FROM _v_sys_database d
LEFT JOIN _v_sys_object_data sod ON d.objname = sod.dbname
LEFT JOIN _v_sys_object_storage_size soss ON sod.objid = soss.tblid
WHERE sod.objtype IN (‘TABLE’, ‘MVIEW_STORE’)
AND sod.dbname = ‘MY_DB_UTILS’
ORDER BY sod.dbname, used_bytes_by_db_and_user DESC, sod.owner, soss.used_bytes DESC;