Oracle Developer's Share

SQL、PL/SQL、Form、Report、Sysadmin、ERP、Error Log

2018-06-28

[SQL]Table Partition佔用空間大小

Oracle space

SELECT   s.segment_name,
         DECODE(SUM(BYTES), NULL, 0, SUM(BYTES) / 1024 / 1024) mbytes
FROM     dba_segments s
WHERE    s.segment_type = 'TABLE PARTITION'
GROUP BY s.segment_name

Google

 

系列文章

標籤雲