[大数据]达梦数据库日常检查

日志检查

数据库服务器日志：/opt/dm8/log/dm_实例名称_月份.log

系统空间使用率

df -hT

表空间使用率

select
t.name as tablespace_name,
sum(d.free_size * d.page_size / 1024 / 1024) as "free_space(M)",
sum(d.total_size * d.page_size / 1024 / 1024) as "total_space(M)",
sum(d.free_size * 100) / sum(d.total_size) as "free_percent(%)"
from v$tablespace t, v$datafile d
where t.id=d.group_id
group by t.name;

数据文件状态检查

select path, status$, rw_status from v$datafile;

失效对象检查

select owner, object_name, object_type, status from dba_objects where dba_objects.status='INVALID';

异常对象检查

select owner, tablespace_name, table_name from dba_tables where tablespace_name='MAIN';
select owner, tablespace_name, table_name, index_name from dba_indexes from dba_indexes where tablespace_name='MAIN';

参数值优化

select * from v$dm_ini where para_name in ('max_sessions', 'max_session_statement', 'compatible_mode');
max_sessions推荐值：8k
session_statement推荐值：2k
compatible_mode推荐值：2-兼容Oracle

备份结果检查

性能检查