达梦日常运维日常SQL(持续更新ing)

• 查看数据文件

select path , status$ , free_size/1024 , page_Size from v$datafile;

• redo log

select file_id , path , rlog_size/1024/1024 MB from v$rlogfile;

• 修改redo大小

alter database resize logfile '/dm/data/DAMENG/DAMENG01.log' to 500;

• 添加redo

alter database add logfile '/dm/data/DAMENG/DAMENG03.log' size 500;

• 归档日志信息

select arch_name , arch_type , arch_dest , arch_file_size arch_space_limit from v$dm_arch_ini;

• 控制文件信息

select para_name , para_value from v$dm_ini where para_name ='CTL_PATH';

• 表空间

select tablespace_name , blocks , bytes/1024/1024 from dba_free_space;

• 分区表

select owner , table_name , partitioned from dba_tables where table_name='T1';

select * from dba_tab_partitions where table_name

---

• 全文索引

select * from schema.syscontextindexes;