EastChilde的博客

https://blog.csdn.net/weixin_44092289/article/details/88539614

https://blog.csdn.net/qq_36582604/article/details/80526287

SELECT acc.id,acc.acc_username,acc.acc_showname,T_PM_ROLE.role_name FROM T_ACCOUNT acc,T_ACCOUNT_R_ROLE accRole ,T_PM_ROLE WHERE acc.is_active =1 AND (accRole.is_active =1 AND acc.id = accRole.acc...

简单的一条update语句执行很久没反应update user set name = '张三' where userid = '001'类似上面这样一句超级简单的update更新的语句，就是死活“正在执行”然后就......没有然后了解决方案：查看锁表进程SQL语句select sess.sid,sess.serial#,lo.oracle_username,...