--查詢每個表的數(shù)據(jù)容量大小
SELECT 
    owner AS  schema_name,
    table_name AS 表名,
    num_rows AS 記錄數(shù),
    blocks * 8  AS  數(shù)據(jù)大小_KB,
    ROUND((blocks * 8 / 1024/1024), 2) AS 占用空間_GB,
    ROUND((num_rows * avg_row_len / 1024 / 1024 / 1024), 2) AS 預(yù)估數(shù)據(jù)大小_GB,
    avg_row_len  AS  平均每行長度_bytes,
    tablespace_name  AS 表空間
FROM all_tables 
WHERE owner = 'ODS'
AND   table_name IN 
(
    'ODS_YTH_SRV_EVENT',
    'ODS_YTH_INV_WI',
    'ODS_YTH_INV_MOVE_EVENT',        
    'ODS_YTH_INV_UNIT',
    'ODS_YTH_REF_EQUIPMENT',
    'ODS_YTH_INV_UNIT_FCY_VISIT'
)
ORDER BY num_rows DESC NULLS LAST;