pl/sql死锁情况:record is locked by another user
pl/sql死锁情况:record is locked by another user
由于出现了问题，我在某君博客里找到了解决方案，一试之下，发现方案可行！
害怕记性不好，所以在这分享下！也是作为自己的查找方向
一、PL/SQL 查看锁:
select t2.username,t2.sid,t2.serial#,t2.logon_time
from v$locked_object t1,v$session t2
where t1.session_id = t2.sid&
order t2.logon_
或者在pl/sql developer 中用管理员账号登陆，点击菜单栏里session查看所有人的登陆信息
二、查看锁后，找出sid,serial#,将所有的锁kill掉
alter system kill session 'sid,serial#'
(window.slotbydup=window.slotbydup || []).push({
id: '2467140',
container: s,
size: '1000,90',
display: 'inlay-fix'
(window.slotbydup=window.slotbydup || []).push({
id: '2467141',
container: s,
size: '1000,90',
display: 'inlay-fix'
(window.slotbydup=window.slotbydup || []).push({
id: '2467143',
container: s,
size: '1000,90',
display: 'inlay-fix'
(window.slotbydup=window.slotbydup || []).push({
id: '2467148',
container: s,
size: '1000,90',
display: 'inlay-fix'In Internet Explorer, press the key combination Alt + X to open the
Tools menu.
Click Internet options.
Click the Advanced tab.
Reset... button.
Enable the Delete personal settings option.
This will reset your Internet Explorer to its default settings. Your browser will start with the familiar start page and search engine—without popups, ads, cookies, but all browser add-ons are deleted too . Make cleaning up your browser and your computer simpler and safer with .
User&Comments
a major nuisance with pop-upcreen interfering every 15 seconds. & George Burton &
it appeared out of the blue after i opened emaiamd will not let me operate my cpu easily. a real menace to using my Windows XP Pro. & george b &
This file can sometimes be a "BitCoin miner" application, spread through downloaded programs.
You can tell if it is indeed a BC minor if it eats your RAM and uses CPU power. & Bob Holloway &
Unable to shutdown XP Professional.
Using Windows Task Manager, select Monitor.exe and then End Process.
You can then shutdown Windows.
It appears to have been installed under C:\Program Files\LeapFrog\LeapFrog Connect (118,272 bytes) It automatically runs on Windows startup.
I will uninstall this application.
& Mike B &
it was installed by my Genius camera SW & jospen &
Found it installed after I installed a web-cam driver.
File signed by pixart.TW, (camera manufacturers) but actually downloaded from a link supplied by microsoft trouble shooter. & Bill &
It can also be a part of "Natec Genesis Gamin Gear" keyboard software. Monitor.exe and osd.exe. & Kitsune &
I don't have iObit and it has permissions to administrators and cannot be removed &
More comments can be found here: &
Summary: Average user rating of Monitor.exe:
based on 69 votes with 9 reviews.
41&users think Monitor.exe is essential for Windows or an installed application.
8&users think it's probably harmless.
10&users think it's neither essential nor dangerous.
3&users suspect danger.
7&users think Monitor.exe is dangerous and recommend removing it.
10&users don't grade Monitor.exe ("not sure about it").
Best practices for resolving Monitor issues
A clean and tidy computer is the key requirement for avoiding problems with Monitor. This means running a scan for malware, cleaning your hard drive using
and , uninstalling programs that you no longer need, checking for Autostart programs (using ) and enabling Windows' . Always remember to perform periodic backups, or at least to set restore points.
Should you experience an actual problem, try to recall the last thing you did, or the last thing you installed before the problem appeared for the first time. Use the
command to identify the processes that are causing your problem. Even for serious problems, rather than reinstalling Windows, you are better off repairing of your installation or, for Windows 8 and later versions, executing the
command. This allows you to repair the operating system without losing data.
To help you analyze the Monitor.exe process on your computer, the following programs have proven to be helpful:
displays all running Windows tasks, including embedded hidden processes, such as keyboard and browser monitoring or Autostart entries. A unique security risk rating indicates the likelihood of the process being potential spyware, malware or a Trojan.
detects and removes sleeping spyware, adware, Trojans, keyloggers, malware and trackers from your hard drive.
Other processes
Monitor.exe<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
您的访问请求被拒绝 403 Forbidden - ITeye技术社区
您的访问请求被拒绝
亲爱的会员，您的IP地址所在网段被ITeye拒绝服务，这可能是以下两种情况导致：
一、您所在的网段内有网络爬虫大量抓取ITeye网页，为保证其他人流畅的访问ITeye，该网段被ITeye拒绝
二、您通过某个代理服务器访问ITeye网站，该代理服务器被网络爬虫利用，大量抓取ITeye网页
请您点击按钮解除封锁&record is locked by another user
在更新数据的时候报这个错：
在操作表时没有commit，导致表被锁，只要执行下面两行语句，就可以了将行锁解锁了。
查看被锁表的sid 和 serial
Select t2.username,t2.sid,t2.serial#,t2.logon_time from v$locked_object t1,v$session t2 where t1.session_id=t2.
kill 相应的session
alter system kill session &#39;sid, serial#&#39;;
执行完以上两步后，就可以编辑数据了。
(window.slotbydup=window.slotbydup || []).push({
id: '2467140',
container: s,
size: '1000,90',
display: 'inlay-fix'
(window.slotbydup=window.slotbydup || []).push({
id: '2467141',
container: s,
size: '1000,90',
display: 'inlay-fix'
(window.slotbydup=window.slotbydup || []).push({
id: '2467143',
container: s,
size: '1000,90',
display: 'inlay-fix'
(window.slotbydup=window.slotbydup || []).push({
id: '2467148',
container: s,
size: '1000,90',
display: 'inlay-fix'