Oracle_清理session

> select saddr,sid,serial#,paddr,username,status,program,sql_id from v$session where username =upper('sys');

SADDR SID SERIAL# PADDR USERNAME STATUS PROGRAM SQL_ID
---------------- ---------- ---------- ---------------- ------------------------------ --------------- ------------------------------------------------ -------------
000000794213C608 439 43801 0000007961F56B98 SYS ACTIVE oracle@db01 (O002)
00000079422F4408 1447 63069 0000007921F79D58 SYS INACTIVE oraagent.bin@db01 (TNS V1-V3) 4qm8a3w6a1rfd
00000079A2334F20 1518 64489 0000007981F8EB10 SYS INACTIVE sqlplus@db01db01 (TNS V1-V3)
0000007962457D00 2261 40183 00000079C1F8FA98 SYS ACTIVE oracle@db01 (O003)
0000007922495130 2353 21445 0000007921F8FC70 SYS ACTIVE sqlplus@db01 (TNS V1-V3) 4fmshbrh9ftq3
00000079C2538578 2641 3 0000007921F575A0 SYS INACTIVE oraagent.bin@db01 (TNS V1-V3)

6 rows selected.

根据sql_id,program的值，对v$sql视图进行核对

select * from v$sql where sql_id='4fmshbrh9ftq3';

 

无误之后，清理掉sqlplus的连接，alter system kill session '2353,21445';