(额外)关掉cpu占用100%的进程
top命令查进程号
select a.sid,a.SERIAL# from v$session a,v$process b where a.paddr=b.addr and b.spid=18513;
ALTER SYSTEM KILL SESSION '1708,1569' IMMEDIATE;
关监听:
lsnrctl stop
关连接:
ps aux |grep "LOCAL=NO" |awk '{printf "%s\n", $2}' |xargs kill -9
重启:
sqlplus / as sysdba
shutdown immediate;
startup;