摘要:
查找表中多余的重复记录,重复记录是根据单个字段(Id)来判断 select * from 表 where Id in (select Id from 表 group byId having count(Id) > 1) 2、删除表中多余的重复记录,重复记录是根据单个字段(Id)来判断,只留有rowi 阅读全文
摘要:
begin dbms_workload_repository.create_snapshot(); end; 1、准备 查询dbid select dbid from v$database; 查询instance_number select instance_number from v$instan 阅读全文
摘要:
无效会话 SELECT sid, serial#, inst_id, module, status FROM gv$session s WHERE s.username = 'xxxxx' AND s.last_call_et >= 10 AND s.status = 'INACTIVE' AND 阅读全文