oracle 常用命令集
登录: sqlplus sys/sys@zjport as sysdba;
查连接:select sid, paddr, username, status from v$session;
查进程: select spid from v$process where addr='PADDR';
快速杀掉Session:
windows: C:\>orakill sid spid;
unix: $kill spid;
查看外键状态:
select constraint_name, status from user_constraints where table_name = '表名';