达梦数据库查询数据库所有表名_DM7 达梦数据库 常用的运维SQL语句

1、查看数据库版本号

SQL> select * from v$version;

LINEID BANNER

---------- -------------------------------------------------------------

1 DM Database Server x64 V7.6.0.95-Build(2018.09.13-97108)ENT

2 DB Version: 0x7000a

used time: 4.300(ms). Execute id is 11.

SQL>

2、查看表空间的名称及大小

SQL> select name tablepace_name, total_size*sf_get_page_size()/1024/1024||'m' ts_size from v$tablespace;

LINEID TABLEPACE_NAME TS_SIZE

---------- -------------- -------

1 SYSTEM 24m

2 ROLL 128m

3 TEMP 10m

4 MAIN 128m

5 SYSAUX 128m

used time: 1.839(ms). Execute id is 12.

SQL>

3、 查看表空间物理文件的名称及大小

SQL> select t.name tablespace_name,t.id file_id,d.path file_name,d.total_size*sf_get_page_size()/1024/1024||'m' total_space from v$tablespace t, v$datafile d where t.id=d.group_id;

LINEID TABLESPACE_NAME FILE_ID FILE_NAME TOTAL_SPACE

---------- --------------- ----------- -------------------------------- -----------

1 SYSTEM 0 /dm/dmdbms/data/cndba/SYSTEM.DBF 24m

2 SYSAUX 5 /dm/dmdbms/data/cndba/SYSAWR.DBF 128m

3 MAIN 4 /dm/dmdbms/data/cndba/MAIN.DBF 128m

4 TEMP 3 /dm/dmdbms/data/cndba/TEMP.DBF 10m

5 ROLL 1 /dm/dmdbms/data/cndba/ROLL.DBF 128m

used time: 8.915(ms). Execute id is 13.

SQL>

4、 查看控制文件

SQL> select para_value name from v$dm_ini where para_name='CTL_PATH';

LINEID NAME

---------- ----------------------------

1 /dm/dmdbms/data/cndba/dm.ctl

used time: 9.032(ms). Execute id is 14.

SQL>

5、 查看日志文件

SQL> select PATH,RLOG_SIZE/1024/1024||'M' from v$rlogfile;

LINEID PATH RLOG_SIZE/1024/1024||'M'

---------- --------------------------------- ------------------------

1 /dm/dmdbms/data/cndba