当前位置:网站首页>Oracle lock table query and unlocking method
Oracle lock table query and unlocking method
2022-04-23 13:40:00 【Wangcai 2】
View locked table information
select sess.sid,sess.serial#,
lo.oracle_username ' Login account ',lo.os_user_name ' Log in to your computer ',
ao.object_name ' Locked table name ',lo.locked_mode ' Locked level '
from v$locked_object lo,dba_objects ao,v$session sess
where ao.object_id=lo.object_id and lo.session_id=sess.sid;
Kill the lock table process
alter system kill session '68,51';-- Respectively SID and SERIAL# Number
View the table that caused the lock in the database SQL sentence
SELECT A.USERNAME,
A.MACHINE,
A.PROGRAM,
A.SID,
A.SERIAL#,
A.STATUS,
C.PIECE,
C.SQL_TEXT
FROM V$SESSION A, V$SQLTEXT C
WHERE A.SID IN (SELECT DISTINCT T2.SID
FROM V$LOCKED_OBJECT T1, V$SESSION T2
WHERE T1.SESSION_ID = T2.SID)
AND A.SQL_ADDRESS = C.ADDRESS(+)
ORDER BY C.PIECE;
版权声明
本文为[Wangcai 2]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204230604301244.html
边栏推荐
- RTOS mainstream assessment
- [multi screen interaction] realize dual multi screen display II: startactivity mode
- 【视频】线性回归中的贝叶斯推断与R语言预测工人工资数据|数据分享
- Ding ~ your scholarship has arrived! C certified enterprise scholarship list released
- Feature Engineering of interview summary
- AI21 Labs | Standing on the Shoulders of Giant Frozen Language Models(站在巨大的冷冻语言模型的肩膀上)
- Solve the problem that Oracle needs to set IP every time in the virtual machine
- Longitude and latitude position of provincial capitals in China
- Filter and listener of three web components
- Antd design form verification
猜你喜欢
How to build a line of code with M4 qprotex
Set Jianyun x Feishu Shennuo to help the enterprise operation Department realize office automation
QT calling external program
Isparta is a tool that generates webp, GIF and apng from PNG and supports the transformation of webp, GIF and apng
面试官给我挖坑:单台服务器并发TCP连接数到底可以有多少 ?
为什么从事云原生开发需要学习容器技术
顶级元宇宙游戏Plato Farm,近期动作不断利好频频
You and the 42W bonus pool are one short of the "Changsha bank Cup" Tencent yunqi innovation competition!
【视频】线性回归中的贝叶斯推断与R语言预测工人工资数据|数据分享
SPI NAND flash summary
随机推荐
Playwright contrôle l'ouverture de la navigation Google locale et télécharge des fichiers
Ai21 labs | standing on the shoulders of giant frozen language models
[point cloud series] unsupervised multi task feature learning on point clouds
innobackupex增量备份
2020年最新字节跳动Android开发者常见面试题及详细解析
CSDN College Club "famous teacher college trip" -- Hunan Normal University Station
Bottomsheetdialogfragment + viewpager + fragment + recyclerview sliding problem
Solve the problem that Oracle needs to set IP every time in the virtual machine
[point cloud series] pointfilter: point cloud filtering via encoder decoder modeling
2020最新Android大厂高频面试题解析大全(BAT TMD JD 小米)
Exemple de méthode de réalisation de l'action d'usinage à point fixe basée sur l'interruption de déclenchement du compteur à grande vitesse ob40 pendant le voyage de tia Expo
Detailed explanation of ADB shell top command
Why do you need to learn container technology to engage in cloud native development
Servlet of three web components
Data warehouse - what is OLAP
Cross carbon market and Web3 to achieve renewable transformation
Stack protector under armcc / GCC
Imx6ull QEMU bare metal tutorial 1: GPIO, iomux, I2C
./gradlew: Permission denied
为什么从事云原生开发需要学习容器技术