一. 查詢索引相關

1. 查詢索引所在的表空間，單個索引的大小SELECT ui.table_name, us.segment_name AS index_name, us.tablespace_name,ROUND(SUM(us.bytes) / 1024 / 1024 / 1024, 2) AS total_size_GB
FROM dba_indexes ui
JOIN dba_segments us ON ui.index_name = us.segment_name
WHERE ui.owner = '用戶'  -- 替換為實際使用用戶（需大寫）
GROUP BY ui.table_name, us.segment_name, us.tablespace_name
ORDER BY total_size_GB DESC;2.查詢索引所使用的表空間的大小SELECT us.tablespace_name,ROUND(SUM(us.bytes) / 1024 / 1024 / 1024, 2) AS total_size_GB
FROM dba_indexes ui
JOIN dba_segments us ON ui.index_name = us.segment_name
WHERE ui.owner = '用戶'  -- 替換為實際使用用戶（需大寫）
GROUP BY  us.tablespace_name
ORDER BY total_size_GB DESC;