达梦数据库查询表大小

最新推荐文章于 2025-03-25 23:20:45 发布

code12313

最新推荐文章于 2025-03-25 23:20:45 发布

阅读量1.7k

点赞数 5

文章标签：数据库

本文链接：https://blog.youkuaiyun.com/code12313/article/details/135615434

版权

本文介绍了如何使用SQL查询在Oracle数据库中获取DB_WIDM模式下的表大小、表名、索引详细信息，包括索引类型、可见性等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

-- 查询所有表所占的大小及所在空间 
SELECT A.OWNER AS "模式", A.SEGMENT_NAME AS "表名", A.BYTES/1024 AS "大小(KB)", A.TABLESPACE_NAME AS "所属表空间", B.COMMENTS AS "表注释" FROM DBA_SEGMENTS A,DBA_TAB_COMMENTS B WHERE A.OWNER=B.OWNER AND A.SEGMENT_NAME = B.TABLE_NAME AND A.OWNER='DB_WIDM' ORDER BY SEGMENT_NAME ASC;

-- 查询索引 
SELECT TABLE_OWNER AS "表归属", TABLE_NAME AS "表名", OWNER AS "索引归属", INDEX_NAME AS "索引名", INDEX_TYPE AS "索引类型", TABLESPACE_NAME AS "索引所在表空间", JOIN_INDEX AS "是否组合索引", -- if-else的效果 DECODE(VISIBILITY,'VISIBLE','可见','INVISIBLE','不可见') AS "索引是否可见" FROM DBA_INDEXES WHERE OWNER='DB_WIDM';