数据库安装完成后，在%DM_HOME%/doc文件夹下面的DM8 DBA.pdf手册中，附录一和附录二章节 有详细介绍。

查询模式下表大小、表注释、表空间：
SELECT A.OWNER AS “模式”,A.SEGMENT_NAME AS “表名”,A.BYTES/1024/1024 AS “大小(M)”,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=‘SYSDBA’ ORDER BY SEGMENT_NAME ASC;

查询模式下表的列、列注释：
SELECT A.OWNER AS “模式”,A.TABLE_NAME AS “表名”,A.COLUMN_NAME AS “列名”,A.DATA_TYPE AS “列类型”,A.DATA_LENGTH AS “列长度”,A.COLUMN_ID AS “列序号”,DECODE(A.NULLABLE,‘Y’,‘是’,‘N’,‘否’) AS “是否可为空”,B.COMMENTS AS “注释” FROM DBA_TAB_COLUMNS A,DBA_COL_COMMENTS B WHERE A.OWNER=B.OWNER AND A.TABLE_NAME=B.TABLE_NAME AND A.COLUMN_NAME=B.COLUMN_NAME AND A.OWNER=‘SYSDBA’;

查询SYSDBA下存在哪些表：（SYSDBA用户可以替换成你想要查询的模式名）
SELECT NAME AS “表名” FROM SYSOBJECTS WHERE SUBTYPE$=‘UTAB’ AND SCHID IN (SELECT A.ID FROM SYSOBJECTS A,ALL_USERS B WHERE A.TYPE$=‘SCH’ AND A.PID=B.USER_ID AND A.NAME=‘SYSDBA’);