Oracle查看历史锁信息

最新推荐文章于 2024-05-21 18:51:16 发布
最新推荐文章于 2024-05-21 18:51:16 发布
阅读量6k 收藏 14
点赞数 2
分类专栏： Oracle日常运维 文章标签： oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_37625564/article/details/114299402
版权

早上9点多的时候，客户反映在七点多他发现数据库中有TX锁，他执行了alter system kill session动作，现在希望我们帮忙查一下当时那个时间点造成锁的原因、语句等信息。
他执行kill session的操作是 ALTER SYSTEM KILL SESSION ‘401,40975’;

这种情况下可以通过v$active_session_history视图查询到历史记录

SQL> col event for a20
SQL> set linesize 180 pagesize 10000
SQL> select SAMPLE_TIME,session_id,sql_id,event,p1,BLOCKING_SESSION from v$active_session_history where event = 'enq: TX - row lock contention'
  2  and sample_time >to_timestamp('2021-03-03 04:00:00','yyyy-mm-dd hh24:mi:ss')
  3  and sample_time <to_timestamp('2021-03-03 09:00:00','yyyy-mm-dd hh24:mi:ss') and session_id=401;

SAMPLE_TIME                                                                 SESSION_ID SQL_ID                                  EVENT                        P1 BLOCKING_SESSION
--------------------------------------------------------------------------- ---------- --------------------------------------- -------------------- ---------- ----------------
03-MAR-21 07.53.25.282 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.24.282 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.23.282 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.22.282 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.21.282 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.20.282 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.19.282 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.18.272 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.17.272 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.16.272 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.15.272 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.14.272 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.13.272 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.12.252 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.11.252 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.10.252 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.09.252 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.08.252 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.07.252 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.06.252 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.05.252 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.04.242 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.03.242 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.02.242 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.01.242 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.53.00.242 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.59.232 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.58.232 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.57.222 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.56.222 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.55.222 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.54.222 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.53.222 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.52.212 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.51.212 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.50.212 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.49.212 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.48.212 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.47.212 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.46.202 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.45.202 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.44.202 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.43.192 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.42.192 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.41.192 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.40.192 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.39.192 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.38.192 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.33.182 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.32.182 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.31.182 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.30.182 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.29.172 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.28.172 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.27.172 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.26.162 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.25.162 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.24.162 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.23.162 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.22.162 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.21.162 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.20.162 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.19.162 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.18.152 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.17.152 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.16.152 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.15.152 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.14.152 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.13.132 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.12.105 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.11.105 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.10.105 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.09.105 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.08.105 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.07.105 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.06.105 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.05.105 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.04.105 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.03.095 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.02.095 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention

03-MAR-21 07.52.01.095 AM                                                          401 50s6rmpvj3hg8                           enq: TX - row lock c 1415053318             2284
                                                                                                                               ontention


81 rows selected.

查询得知，在早上7点52分左右，401会话上执行了50s6rmpvj3hg8 SQL语句，造成了大量了阻塞，阻塞了2284会话
通过v$sql查询该SQL的文本信息

SQL> set linesize 200;
SQL> col sql_text for a100;
SQL> select sql_id,sql_text from v$sql where sql_id='50s6rmpvj3hg8';

SQL_ID                                  SQL_TEXT
--------------------------------------- ----------------------------------------------------------------------------------------------------
50s6rmpvj3hg8                           update GY_xhb SET dqz =dqz + zz WHERE bm =:1
50s6rmpvj3hg8                           update GY_xhb SET dqz =dqz + zz WHERE bm =:1
50s6rmpvj3hg8                           update GY_xhb SET dqz =dqz + zz WHERE bm =:1
50s6rmpvj3hg8                           update GY_xhb SET dqz =dqz + zz WHERE bm =:1
50s6rmpvj3hg8                           update GY_xhb SET dqz =dqz + zz WHERE bm =:1
50s6rmpvj3hg8                           update GY_xhb SET dqz =dqz + zz WHERE bm =:1
50s6rmpvj3hg8                           update GY_xhb SET dqz =dqz + zz WHERE bm =:1
50s6rmpvj3hg8                           update GY_xhb SET dqz =dqz + zz WHERE bm =:1

8 rows selected.

将SQL语句递交给客户研发部门，至此，问题解决

挠背小能手
关注
  • 2
    点赞
  • 踩
  • 14
    收藏
    觉得还不错? 一键收藏
  • 3
    评论
专栏目录
oracle锁表历史,查看oracle死锁历程并结束死锁
weixin_42303078的博客
04-02 1788
当前位置:我的异常网» 数据库»查看oracle死锁历程并结束死锁查看oracle死锁历程并结束死锁www.myexceptions.net网友分享于：2015-08-26浏览：15次查看oracle死锁进程并结束死锁查看锁表进程SQL语句1：select sess.sid,sess.serial#,lo.oracle_username,lo.os_user_name,ao.objec...
如何定位Oracle数据库被锁阻塞会话的根源？
12-14
除了以上基本步骤，还可以利用Oracle提供的其他工具，如DBA_HIST_ACTIVE_SESS_HISTORY表（用于AWR报告）和ASH（Active Session History）分析，这些工具可以帮助分析历史锁等待情况，找出问题的根本原因，从而优化...
oracle锁诊断及解决
梦想氧吧
01-03 277
1、查看数据库锁,诊断锁的来源及类型： select object_id,session_id,locked_mode from v$locked_object; 或者用以下命令： select b.owner,b.object_name,l.session_id,l.locked_mode from v$locked_object l, dba_object...
oracle 历史锁表sql,ORACLE下查看锁表记录的SQL语句
weixin_28997879的博客
04-03 781
SELECT A.OWNER 方案名,A.OBJECT_NAME 表名,B.XIDUSN 回滚段号,B.XIDSLOT 槽号,B.XIDSQN 序列号,B.SESSION_ID 锁表SESSION_ID,B.ORACLE_USERNAME 锁表用户名,decode(D.type,'XR','NULL','RS','SS(Row-S)','CF','SS(Row-S)','TM','TABLE LO...
Oracle死锁的查看以及解决办法
最新发布
lc547913923的专栏
05-21 2719
（其中sid=l.session_id）其中spid是这个进程的进程号，kill掉这个Oracle进程。Lockwait：死锁的状态，如果有内容表示被死锁。Program： 产生死锁的语句主要来自哪个应用程序。Username：死锁语句所用的数据库用户；Status： 状态，active表示被死锁。其中sid用死锁的sid替换: exit。Machine： 死锁语句所在的机器。1、查看死锁是否存在。
Oracle 临时表、数据闪回、查询被锁表、系统常用表、及常用操作
蚩尤后裔-汪茂雄
12-30 4673
Oracle 临时表概述 1、临时表用于存储事务或会话的中间结果集数据，临时表中保存的数据只对当前会话或事务可见，所有会话都看不到其他会话的数据，所以临时表不存在并发行为。 2、创建临时表时，Oracle 只创建了表的结构，并没有初始化内存空间，只有向临时表中插入数据时，才会给临时表分配存储空间。 3、临时表也是实实在在存在的表，可以对它创建索引、视图、触发器等操作，与非临时表的区别主要在于数据的可见性与存在时间。 4、临时表分事务级临时表和会话级临时表，事务级临时表只对当前事务有效，每次提交后 O
oracle锁历史信息,一些与oracle相关的关于查询锁的信息
weixin_29383401的博客
04-02 395
1、查询那些表被锁住了10:16:41 sys@PORTALDB> select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id=a.object_id;no rows selected2、查处引起死锁的会话select b.user...
oracle锁表历史,Oracle锁表问题
weixin_42526015的博客
04-02 429
--以下几个为相关表SELECT * FROM vsqlarea;SELECT * FROM vprocess ;SELECT * FROM vsession_wait;--查看被锁的表select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object...
oracle 锁表，锁对象，锁记录
lijilinjy的专栏
08-29 1955
1、查询锁表记录2、杀死锁表进程。
Oracle 查看锁表信息及处理方式
quyingzhe0217的博客
09-22 624
查看索赔信息 select t1.ORACLE_USERNAME, t1.OS_USER_NAME, t2.OWNER, t2.OBJECT_TYPE, t2.OBJECT_NAME, t2.status, t3.SID, t3.SERIAL#, t4.PID, t4.SPID from vlockedobjectt1,dbaobjectst2,vlocked_object t1, dba_objects t2, vlockedo​bjectt1,dbao​bjectst2,vsession t3, v$p
Oracle的SQL监视工具SQLTracker
04-19
1. **实时SQL监控**：能够实时显示正在执行的SQL语句，包括执行时间、资源消耗等信息，帮助用户快速定位慢查询。 2. **历史查询分析**：记录并存储过去的SQL执行记录，便于对比不同时间点的性能变化，进行长期性能...
删除锁表语句
02-27
另外，还可以通过查看更详细的锁定信息来进行分析和决策： ```sql SELECT l.session_id sid, s.serial#, l.locked_mode, l.oracle_username, l.os_user_name, s.machine, s.terminal, o.object_name, s.logon_time ...
Oracle 性能诊断艺术
05-07
1. **性能监控与分析**：书中详细介绍了Oracle的性能监控工具，如SQL Trace、TKPROF、AWR(自动工作负载存储库)和ASH(活动会话历史)等，这些都是DBA日常工作中不可或缺的性能分析手段。通过这些工具，可以追踪SQL语句...
Oracle 数据库 AWR 报告详解
10-13
AWR（Automatic Workload Repository）是 Oracle 数据库 10g 中引入的一项关键特性，用于收集和存储数据库的历史性能数据。AWR 报告提供了详细的数据库性能信息，包括 CPU 使用率、磁盘 I/O、内存使用情况、锁等待...
IMPDP出现ORA-39001 ORA-39000 ORA-39142错误
m0_37625564的博客
03-02 9668
目标端IMPDP导入时出现ORA-39001 ORA-39000 ORA-39142错误 D:\>impdp a/b@1.1.1.1:1521/pdborcl directory=dp dumpfile=test0301.dmp logfi le=impdp_test0301.log Import: Release 12.1.0.2.0 - Production on 星期三 3月 2 09:22:26 2022 Copyright (c) 1982, 2014, Oracle and/or it
ORA-12516: TNS:listener could not find available handler with matching protocol stack解决方法
m0_37625564的博客
05-11 9405
某天，业务部门反应前端肯定业务端无法访问数据库，在数据库上尝试连接数据库： sqlplus a/b@192.168.0.160:1521/orcl ORA-12516: TNS:listener could not find available handler with matching protocol stack 查看监听日志 11-MAY-2021 09:18:47 * (CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=D:\MEDIINFO\EMRCS
Oracle查看ASM磁盘组中各目录大小
m0_37625564的博客
06-22 8206
在实际生产中，往往会碰到一套RAC中运行多个数据库，ASM某磁盘组中按照各数据库创建目录，因此ASM某磁盘组中会有很多个目录，例如环境描述为： [grid@ray01 ~]$ asmcmd ASMCMD> lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED
Oracle闪回查询
m0_37625564的博客
09-01 7110
Oracle闪回查询，用于查询数据库过去指定时间的数据状态。 SELECT obj# FROM obj$ AS OF TIMESTAMP TO_TIMESTAMP('2018-03-22 18:42:00', 'YYYY-MM-DD HH24:MI:SS') WHERE NAME = 'RAYT1' and owner#=90; 如果要用此功能来捞数据，可通过闪回查询+创建表的方式捞取数据 CREATE TABLE RAYT1_FLASH AS SELECT * FROM RAYT1 AS OF TI
oracle查看历史死锁
06-08
要查看Oracle中的历史死锁，可以通过以下步骤： 1. 查询V$LOCK_HISTORY视图，该视图包含了所有被锁定的对象和锁定它们的会话的信息，包括锁定的时间、锁定类型、锁定模式等。 2. 使用以下SQL语句查询V$LOCK_HISTORY视图中的信息： SELECT * FROM V$LOCK_HISTORY; 这将返回所有历史死锁的详细信息。 3. 使用以下SQL语句过滤出最近一段时间内的历史死锁信息： SELECT * FROM V$LOCK_HISTORY WHERE SAMPLE_TIME > SYSDATE - 7; 在此示例中，将返回过去7天内的历史死锁信息。 请注意，查询V$LOCK_HISTORY视图可能会对Oracle数据库的性能产生一定的影响，因此建议仅在必要时使用该视图。
评论 3
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值