1、查看死锁1)用dba用户执行以下语句select username,lockwait,status,machine,program from v$session where sid in (select session_id from v$locked_object)如果有输出的结果,则说明有死锁,且能看到死锁的机器是哪一台。字段说明:Username..
//根据用户分组会话select t.USERNAME,count(*) from v$session t group by t.USERNAME//查找某一用户正在执行的sql_id值select * from v$session t where t.USERNAME = 'BUDGET' and t.SQL_ID is not null//查找对应sql_id的对应sql语句select m.S..