数据库卡死？根据如下sql分析数据库sql执行情况

删除一个字段中的重复数据 保存一条数据

DELETE from 表 WHERE (id) IN ( SELECT id FROM 表 GROUP BY id HAVING COUNT(id) > 1) 
AND ROWID NOT IN (SELECT MIN(ROWID) FROM 表 GROUP BY id HAVING COUNT(*) > 1);
--第二种写法
select * from (select id,字段1,字段1,row_number() over (partition by card order by 字段3 desc) as rn
 from 表 ) where rn = 1

查看当前Oracle连接数：

select count(*) from v$process

查看目前项目消耗io资源的sql

select
      'ALTER system kill session $ '|| sid||','||serial# sid,'$;',--拼接强制结束sql代码
'alter system  kill session  '''||a.sid || ','|| a.serial# ||'''; ',
--       substr(program,1,19) prog,
--       address,
       substr(a.event,1,15) event,
--       substr(b.sql_profile,9,31) sqlprofile,
--       hash_value,
       b.sql_id||','||child_number sql_id,
       plan_hash_value,
       executions execs,
       (elapsed_time/decode(nvl(executions,0),0,1,executions))/1000000 avg_ela,
       last_call_et last_ela,
       sql_text
from v$session a, v$sql b
where status = 'ACTIVE'
and username is not null
and a.sql_id = b.sql_id
and a.sql_child_number = b.child_number
and sql_text not like '%from v$session a, v$sql b%'
and a.program not like '%(P%)'
order by plan_hash_value,last_call_et,sql_id, sql_child_number

查看执行该sql的机器名

select machine from gv$session where sql_id='2b064ybzkwf1y,0'

查看sql执行计划，查询总数

select
       plan_hash_value phv,
       lpad(' ',depth)||operation||' '||options operation,
       object_name object,
       cost,
       cardinality "ROWS",
       time
from v$sql_plan
where sql_id='3gxdkbf60ujcd'
order by sql_id,plan_hash_value,id

select 
       plan_hash_value phv,
       lpad(' ',depth)||operation||' '||options operation,
       object_name object,
       cost,
       cardinality "ROWS",
       time
from dba_hist_sql_plan
where sql_id='3gxdkbf60ujcd'
order by sql_id,plan_hash_value,id