- 博客(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 53
原创 2021-04-20
Oracle报 ORA-00054资源正忙的解决办法来源于:http://www.cnblogs.com/loveLearning/p/3625544.htmloracle之报错:ORA-00054: 资源正忙,要求指定 NOWAIT问题如下:SQL> conn scott/tiger@vm_databaseConnected to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0Connected as sc.
2021-04-20 15:36:28 176
原创 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 465
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人