摘要： 查找表中多余的重复记录，重复记录是根据单个字段（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 阅读全文