Oracle 常用系统表
1、查询一直列明在哪些表中出现
SELECT t.owner,t.table_name FROM all_tab_columns t WHERE t.COLUMN_NAME ='XXXXX' AND .....
2、表被锁以及解锁
--查询锁表对象 select object_name,machine,s.sid,s.serial# from v$locked_object l,dba_objects o ,v$session s where l.object_id = o.object_id and l.session_id=s.sid; --关闭锁表的会话 alter system kill session 'sid,seial#';
3、存储过程被锁
--查找sid select sid,object from v$access where object like '%XXXXX%' --查询sid,serial# select sid,serial# ,paddr from v$session where sid = ''; --kill session alter system kill session 'sid,serial#';