- 博客(3)
- 资源 (1)
- 收藏
- 关注
原创 2021-05-14
select session_id from v$locked_object / SELECT sid, serial#, username, osuser FROM v$session where sid = 247 / SELECT sid||','||serial# FROM v$session where sid = (select session_id from v$locked_object) / ALTER SYSTEM KILL SESSION '247,14792'
2021-05-14 14:42:00
58
原创 2021-04-20
Oracle报 ORA-00054资源正忙的解决办法 来源于:http://www.cnblogs.com/loveLearning/p/3625544.html oracle之报错:ORA-00054: 资源正忙,要求指定 NOWAIT 问题如下: SQL> conn scott/tiger@vm_database Connected to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 Connected as sc.
2021-04-20 15:36:28
186
原创 Oracle 查询用户空表
begin for R in (select table_name AS tname from user_tables) loop execute immediate 'analyze table '|| R.tname ||' compute statistics'; null; end loop; end; / SELECT * FROM USER_TABLES where num_rows = 0
2020-09-08 09:39:15
502
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人