随笔分类 - ORACLE PL/SQL
摘要:1.SELECT * FROM V$DB_OBJECT_CACHE WHERE name='NCCM_MEDICAL_USERSTATS2' AND LOCKS!='0'; 2.select SID from V$ACCESS WHERE object='NCCM_MEDICAL_USERSTATS2';3.SELECT SID,SERIAL#,PADDR FROM V$SESSION WHERE SID='135'; 4.alter system kill session '135,50430' immediat
阅读全文

浙公网安备 33010602011771号