随笔分类 -  oracle

摘要：SELECT table_name FROM dba_tab_columns WHERE column_name = upper('userid') ORDER BY table_name; 阅读全文

摘要：select object_name, oracle_username, 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 阅读全文