--方式1SELECT E.SEGMENT_NAME,SUM(E.BYTES)/1024/1024AS"表大小(M)",ROUND(SUM(E.BYTES)/1024/1024/1024,2)AS"表大小(G)"FROM USER_EXTENTS E
WHERE E.SEGMENT_NAME LIKE'DWR_LOT_DEFECT_HIS_M'GROUPBY E.SEGMENT_NAME;--方式二SELECT T.OWNER,T.SEGMENT_NAME,ROUND(SUM(T.BYTES /1024/1024/1024),2)AS"占用空间(G)"FROM DBA_SEGMENTS T
WHERE T.SEGMENT_NAME ='DWR_LOT_DEFECT_HIS_M'GROUPBY T.OWNER,T.SEGMENT_NAME;
查看分区表大小
SELECT T.OWNER,T.TABLESPACE_NAME,T.SEGMENT_NAME,T.PARTITION_NAME,(T.BYTES /1024/1024)AS"占用空间(M)",ROUND((T.BYTES /1024/1024/1024),2)AS"占用空间(G)"FROM DBA_SEGMENTS T
WHERE T.SEGMENT_NAME ='DWR_LOT_DEFECT_HIS_M'ORDERBY T.SEGMENT_NAME, T.PARTITION_NAME;
查看表空间使用情况大小
SELECT UPPER(F.TABLESPACE_NAME)"表空间名",
D.TOT_GROOTTE_MB "表空间大小(M)",
D.TOT_GROOTTE_MB - F.TOTAL_BYTES "已使用空间(M)",
TO_CHAR(ROUND((D.TOT_GROOTTE_MB - F.TOTAL_BYTES)/ D.TOT_GROOTTE_MB *100,2),'990.99')||'%'"使用比",
F.TOTAL_BYTES "空闲空间(M)",
F.MAX_BYTES "最大块(M)"FROM(SELECT TABLESPACE_NAME,ROUND(SUM(BYTES)/(1024*1024),2) TOTAL_BYTES,ROUND(MAX(BYTES)/(1024*1024),2) MAX_BYTES
FROM SYS.DBA_FREE_SPACE
GROUPBY TABLESPACE_NAME) F,(SELECT DD.TABLESPACE_NAME,ROUND(SUM(DD.BYTES)/(1024*1024),2) TOT_GROOTTE_MB
FROM SYS.DBA_DATA_FILES DD
GROUPBY DD.TABLESPACE_NAME) D
WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME
AND D.TABLESPACE_NAME LIKE'UNDOTBS%'ORDERBY1;
查看(分区)表、表空间大小SQL查看表大小--方式1SELECT E.SEGMENT_NAME, SUM(E.BYTES)/1024/1024 AS "表大小(M)", ROUND(SUM(E.BYTES)/1024/1024/1024,2) AS "表大小(G)" FROM USER_EXTENTS E WHERE E.SEGMENT_NAME LIKE 'DWR_LOT_DEFEC...