【Oracle】—— 查询表占用空间

更新日志：

• [2019-10-15]
  文章发布

说明：

• 本文地址
  • 《【Oracle】—— 查询表占用空间》https://blog.csdn.net/maixiaochai/article/details/102573913
• 关于 MaiXiaochai
  • CSDN：https://blog.csdn.net/maixiaochai
  • GitHub：https://github.com/MaiXiaochai

---

1. 非分区表的查询

•   -- 注意替换 your_username 为要查询的用户名，并且要全大写
    SELECT
    	TABLE_NAME,
    	NVL( BYTES, 0 ),
    	NVL( BYTES / 1024, 0 ) KB,
    	NVL( BYTES / 1024 / 1024, 0 ) MB,
    	NVL( BYTES / 1024 / 1024 / 1024, 0 ) GB 
    FROM
    	DBA_TABLES
    	LEFT JOIN DBA_SEGMENTS ON TABLE_NAME = SEGMENT_NAME 
    	AND SEGMENT_TYPE = 'TABLE'
    	AND DBA_SEGMENTS.OWNER = 'YOUR_USERNAME' 
    WHERE
    	DBA_TABLES.OWNER = 'YOUR_USERNAME' 
    ORDER BY
    	NVL( BYTES, 0 ) DESC;
  

• 

2. 分区表的查询

•   -- -- 注意替换 your_username 为要查询的用户名，并且要全大写
    SELECT
    	TABLE_NAME,
    	NVL( BYTES, 0 ),
    	NVL( BYTES / 1024, 0 ) KB,
    	NVL( BYTES / 1024 / 1024, 0 ) MB,
    	NVL( BYTES / 1024 / 1024 / 1024, 0 ) GB 
    FROM
    	DBA_TABLES
    	LEFT JOIN DBA_SEGMENTS ON TABLE_NAME = SEGMENT_NAME 
    	AND SEGMENT_TYPE = 'TABLE PARTITION'
    	AND DBA_SEGMENTS.OWNER = 'YOUR_USERNAME' 
    WHERE
    	DBA_TABLES.OWNER = 'YOUR_USERNAME' 
    ORDER BY
    	NVL( BYTES, 0 ) DESC;
  

• 

---

The end.