摘要: 1、windows:找到orcle的进程[ORACLE.EXE]c:>netstat -bo杀掉进程c:>taskkill /pid pid /Fc:>sqlplus / as sysdbac:>show parameter processes;c:>alter system set process 阅读全文
posted @ 2020-05-15 10:26 飞鸽子 阅读(1830) 评论(0) 推荐(0) 编辑
摘要: 查询当前数据库锁的sql: Select a.Session_Id, c.Serial#, a.Locked_Mode, b.Object_Id, b.Object_Name, b.Object_Type, c.Logon_Time, a.Oracle_Username, a.Os_User_Nam 阅读全文
posted @ 2020-05-15 10:25 飞鸽子 阅读(547) 评论(0) 推荐(0) 编辑