当前位置:网站首页>It is found that several WRH tables are locked, what should I do?
It is found that several WRH tables are locked, what should I do?
2022-08-04 08:34:00 【mycontrol】
Found that these tables were locked
SQL> select b.owner,b.object_name,a.session_id,a.locked_mode 2 from v$locked_object a,dba_objects b3 where b.object_id = a.object_id;OWNER OBJECT_NAME SESSION_ID LOCKED_MODE------------------------------ -------------------------------------------------------------------------------- ---------- -----------SYS WRH$_EVENT_NAME 331 3SYS WRH$_LATCH_NAME 331 3SYS WRH$_STAT_NAME 331 3SYS WRH$_PARAMETER_NAME 331 3SYS WRH$_METRIC_NAME 331 3AWR is not turned on either
An error is reported when the process is terminated
SQL> alter system kill session '331, 15';alter system kill session '331, 15'ORA-03113: end of file for communication channelHelp how to deal with this!
Other Answer 1:
PS: After checking, these tables are all empty.
Other Answer 2:
Find the corresponding system process by sid and kill it.
Is it a production environment?
If it is a production environment, proceed with caution
Other Answer 3:
Look at what process this 331 is, it is estimated to be a background process, confirm whether the next process is a critical process, if it is not a critical process, kill it at the operating system level, or if it has no effect at present, find a window to restart it,
/p>
边栏推荐
猜你喜欢
随机推荐
安装GBase 8c数据库的时候,报错显示“Resource:gbase8c already in use”,这怎么处理呢?
MySQL 8.0.29 详细安装(windows zip版)
学会 Arthas,让你 3 年经验掌握 5 年功力
图的基本概念
金仓数据库KingbaseES客户端编程接口指南-JDBC(8. JDBC 元数据处理)
占位,稍后补上
发现WRH几个表被锁了,怎么办?
B站回应HR称“核心用户都是Loser”、求职者是“白嫖党”:已被劝退
安装GBase 8c数据库集群时,报错误码:80000306,显示Dcs cluster not healthy。怎么处理错误呢?
[Computer recording screen] How to use bandicam to record the game setting graphic tutorial
经典二分法查找的进阶题目——LeetCode33 搜索旋转排序数组
技术实现 | 图像检索及其在高德的应用
Typora颜色公式代码大全
【Attention】Dual Attention(DANet) & Fully Attention(FLA)
字符流与字节流的区别
ShowMeAI —— Show u 三连
线程安全问题
线程和进程之间的区别
经典动态规划问题的递归实现方法——LeetCode39 组合总和
js异步变同步、同步变异步

![[STM32] STM32F103 series name and package, memory](/img/01/073f970c8c05ad24f976b26790ba61.png)






