11 2021 档案

摘要: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 FROM V$LOCKED 阅读全文
posted @ 2021-11-19 17:11 一只竹节虫 阅读(90) 评论(0) 推荐(0) 编辑
摘要:-- 查找还在使用临时表的会话SELECT sid, serial# FROM v$session WHERE sid = (SELECT sid FROM v$lock WHERE id1 = (SELECT object_id FROM dba_objects WHERE object_name 阅读全文
posted @ 2021-11-04 17:04 一只竹节虫 阅读(53) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示