随笔分类 -  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 阅读全文
posted @ 2013-12-05 15:51 bj_google 阅读(882) 评论(0) 推荐(0)