达梦数据库用户登录限制查询
select
b.username as "达梦数据库用户名",
a.failed_num as "失败次数限制",
a.failed_attemps as "失败尝试次数",
a.lock_time as "锁定时间(min)"
from sysusers a right join all_users b on a.id=b.user_id;
达梦数据库用户锁定状态查询
select
username as "达梦数据库用户名",
account_status as "账户状态",
lock_date as "锁定时间"
from dba_users;
当前正在执行语句
SELECT * FROM (
SELECT SESS_ID,SQL_TEXT,DATEDIFF(SS,LAST_SEND_TIME,SYSDATE) SS,
SF_GET_SESSION_SQL(SESS_ID) FULLSQL
FROM V$SESSIONS WHERE STATE='ACTIVE')
WHERE SS>=1;
当前导致锁表的SQL查询
select * from v$sessions a, v$lock b where a.trx_id = b.trx_id and a.state='ACTIVE';
查询数据库总大小
select sum(bytes)/1024/1024/1024 as "Size(GB)" from SYS.DBA_DATA_FILES;
查表
select getname(c_name),c_tablename,c_code
from tb_inf_infoset where c_tablename= upper('tb_sta_workflow_history');
查字段
select getname(c_name),c_column_name,c_constant_type
from tb_inf_infoitem where c_infoset_code='TB_STA_WORKFLOW_HISTORY';
查参数值
select getname(c_name),c_code from tp_code_item where c_type_code='PROC_STATUS';
根据字段查表
select getname(c_name), c_tablename, c_code from tb_inf_infoset
where c_code in
(select c_infoset_code from tb_inf_infoitem where getname(c_name) like '%入本单位时间%');
select * fom user_tab_colums where column_name =upper('字段名');