下面2个SQL结果是一样的：
/* Formatted on 2009/05/15 19:07 (Formatter Plus v4.8.7) */
SELECT idex.table_name, idex.index_size index_size_k,
st.BYTES / 1024 table_size_k
FROM (SELECT table_name, SUM (BYTES) / 1024 index_size
FROM dba_indexes i, dba_segments s
WHERE i.owner = 'BUSINESS'
AND i.owner = s.owner
AND i.index_name = s.segment_name
AND s.segment_type = 'INDEX'
GROUP BY table_name) idex,
dba_segments st
WHERE idex.table_name = st.segment_name
AND st.segment_type = 'TABLE'
AND st.owner = 'BUSINESS'
ORDER BY table_size_k DESC;
/* Formatted on 2009/05/15 19:12 (Formatter Plus v4.8.7) */
SELECT table_name, SUM (s.BYTES) / 1024 index_size_k,
AVG (st.BYTES) / 1024 table_size_k
FROM dba_indexes i, dba_segments s, dba_segments st
WHERE i.owner = 'BUSINESS'
AND i.table_name = st.segment_name
AND st.segment_type = 'TABLE'
AND i.owner = s.owner
AND i.index_name = s.segment_name
AND s.segment_type = 'INDEX'
GROUP BY table_name
ORDER BY table_size_k DESC;
/* Formatted on 2009/05/15 19:07 (Formatter Plus v4.8.7) */
SELECT idex.table_name, idex.index_size index_size_k,
st.BYTES / 1024 table_size_k
FROM (SELECT table_name, SUM (BYTES) / 1024 index_size
FROM dba_indexes i, dba_segments s
WHERE i.owner = 'BUSINESS'
AND i.owner = s.owner
AND i.index_name = s.segment_name
AND s.segment_type = 'INDEX'
GROUP BY table_name) idex,
dba_segments st
WHERE idex.table_name = st.segment_name
AND st.segment_type = 'TABLE'
AND st.owner = 'BUSINESS'
ORDER BY table_size_k DESC;
/* Formatted on 2009/05/15 19:12 (Formatter Plus v4.8.7) */
SELECT table_name, SUM (s.BYTES) / 1024 index_size_k,
AVG (st.BYTES) / 1024 table_size_k
FROM dba_indexes i, dba_segments s, dba_segments st
WHERE i.owner = 'BUSINESS'
AND i.table_name = st.segment_name
AND st.segment_type = 'TABLE'
AND i.owner = s.owner
AND i.index_name = s.segment_name
AND s.segment_type = 'INDEX'
GROUP BY table_name
ORDER BY table_size_k DESC;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11411056/viewspace-733402/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
CURSOR_SHARING 含义
下一篇：
Oracle Analyze的用法
请登录后发表评论
登录
全部评论
