查詢使用表空間的TABLE,INDEX,INDEX SUBPARTITION

--查詢使用表空間XDCDA他的TABLE,按倒序排列

SELECT SEGMENT_NAME,
       PARTITION_NAME,
       SEGMENT_TYPE,
       BYTES / (1024 * 1024 * 1024) G
  FROM USER_SEGMENTS
 WHERE TABLESPACE_NAME = 'XDCDATA'
 AND SEGMENT_TYPE='TABLE'
 ORDER BY G DESC




SELECT SEGMENT_NAME,
       PARTITION_NAME,
       SEGMENT_TYPE,
       BYTES / (1024 * 1024 * 1024) G
  FROM USER_SEGMENTS
 WHERE TABLESPACE_NAME = 'XDCIDX'
 ORDER BY G DESC


SELECT SEGMENT_NAME,
       PARTITION_NAME,
       SEGMENT_TYPE,
       BYTES / (1024 * 1024 * 1024) G
  FROM USER_SEGMENTS
 WHERE TABLESPACE_NAME = 'XDCIDX'
 AND SEGMENT_TYPE='INDEX'
 ORDER BY G DESC
 
 SELECT SEGMENT_NAME,
       PARTITION_NAME,
       SEGMENT_TYPE,
       BYTES / (1024 * 1024 * 1024) G
  FROM USER_SEGMENTS
 WHERE TABLESPACE_NAME = 'XDCIDX'
 AND SEGMENT_TYPE='INDEX SUBPARTITION'
 ORDER BY G DESC