Shulou(Shulou.com)06/01 Report--

$cd / data/oracle/SHRARS/backup/export/ITSK0004746383

$sqlplus-s / as sysdba

< killsession.sql set head off set linesize 80 set pagesize 1000 select 'ALTER SYSTEM KILL SESSION '''|| sid ||','|| SERIAL# ||''' immediate;' from v\$session where username IN ('CREDIT', 'METABASE_CREDIT') order by username; exit EOF $sqlplus / as sysdba; SQL>

@ killsession.sql

$cat killsession.sql

ALTER SYSTEM KILL SESSION '1294. 33195' immediate

ALTER SYSTEM KILL SESSION '1295, 50713' immediate

ALTER SYSTEM KILL SESSION '1298, 7193, immediate.

ALTER SYSTEM KILL SESSION '11pr 6559' immediate

ALTER SYSTEM KILL SESSION '12pr 4241' immediate

ALTER SYSTEM KILL SESSION '13pr 43041' immediate

ALTER SYSTEM KILL SESSION '18pr 33047' immediate

ALTER SYSTEM KILL SESSION '20pl 18697' immediate

ALTER SYSTEM KILL SESSION '22pr 43179' immediate

ALTER SYSTEM KILL SESSION '24pr 22839' immediate

ALTER SYSTEM KILL SESSION '25pm 26477' immediate

ALTER SYSTEM KILL SESSION '27pr 39063' immediate

ALTER SYSTEM KILL SESSION '28pr 16391' immediate

ALTER SYSTEM KILL SESSION '3pr 15411' immediate

ALTER SYSTEM KILL SESSION '265, 8067' immediate

ALTER SYSTEM KILL SESSION '266, 18241' immediate

ALTER SYSTEM KILL SESSION '267. 43603' immediate

ALTER SYSTEM KILL SESSION '268, 10399' immediate

ALTER SYSTEM KILL SESSION '274 1221' immediate

ALTER SYSTEM KILL SESSION '275 immediate 62325'

ALTER SYSTEM KILL SESSION '277 immediate 42223'

ALTER SYSTEM KILL SESSION '278, 7343' immediate

ALTER SYSTEM KILL SESSION '282, 35757' immediate

ALTER SYSTEM KILL SESSION '284 4955' immediate

ALTER SYSTEM KILL SESSION '286, 36563' immediate

ALTER SYSTEM KILL SESSION '287, 19961' immediate

ALTER SYSTEM KILL SESSION '515pm 30293' immediate

ALTER SYSTEM KILL SESSION '519, 32899' immediate

ALTER SYSTEM KILL SESSION '522pr 52349' immediate

ALTER SYSTEM KILL SESSION '527J 22901' immediate

ALTER SYSTEM KILL SESSION '529J 32971' immediate

ALTER SYSTEM KILL SESSION '532 immediate 10831'

ALTER SYSTEM KILL SESSION '533, 48323' immediate

ALTER SYSTEM KILL SESSION '534 immediate 20303'

ALTER SYSTEM KILL SESSION '535 and 32059' immediate

ALTER SYSTEM KILL SESSION '536, 17155' immediate

ALTER SYSTEM KILL SESSION '537 immediate 35009'

ALTER SYSTEM KILL SESSION '540, 1325' immediate

ALTER SYSTEM KILL SESSION '544 immediate 11927'

ALTER SYSTEM KILL SESSION '770 immediate 20397'

ALTER SYSTEM KILL SESSION '772 immediate 23053'

ALTER SYSTEM KILL SESSION '773 28053' immediate

ALTER SYSTEM KILL SESSION '782 and 2387' immediate

ALTER SYSTEM KILL SESSION '784 ALTER SYSTEM KILL SESSION 48639' immediate

ALTER SYSTEM KILL SESSION '785. 43135' immediate

ALTER SYSTEM KILL SESSION '786 and 40917' immediate

ALTER SYSTEM KILL SESSION '787, 6837' immediate

ALTER SYSTEM KILL SESSION '790MM 19759' immediate

ALTER SYSTEM KILL SESSION '793, 15377' immediate

ALTER SYSTEM KILL SESSION '794 immediate 43759'

ALTER SYSTEM KILL SESSION '795 immediate 51489'

ALTER SYSTEM KILL SESSION '1027pm 40997' immediate

ALTER SYSTEM KILL SESSION '1031, 65177' immediate

ALTER SYSTEM KILL SESSION '103, 55291' immediate

ALTER SYSTEM KILL SESSION '1036, 36143' immediate

ALTER SYSTEM KILL SESSION '1038 people 59219' immediate

ALTER SYSTEM KILL SESSION '1040 immediate 38831'

ALTER SYSTEM KILL SESSION '1042, 57453' immediate

ALTER SYSTEM KILL SESSION '1044, 25747' immediate.

ALTER SYSTEM KILL SESSION '1045, 57295' immediate

ALTER SYSTEM KILL SESSION '1280d9343' immediate

ALTER SYSTEM KILL SESSION '1281 and 2485' immediate

ALTER SYSTEM KILL SESSION '1284 immediate 34733'

ALTER SYSTEM KILL SESSION '1285 and 4495' immediate

ALTER SYSTEM KILL SESSION '1286, 34371' immediate

ALTER SYSTEM KILL SESSION '1287 immediate 30681'

ALTER SYSTEM KILL SESSION '1288 and 2105' immediate

ALTER SYSTEM KILL SESSION '8pm 50775' immediate

ALTER SYSTEM KILL SESSION '263 and 4043' immediate

ALTER SYSTEM KILL SESSION '273 58961' immediate

ALTER SYSTEM KILL SESSION '524.44481' immediate

ALTER SYSTEM KILL SESSION '531 Magic 26673' immediate

ALTER SYSTEM KILL SESSION '1299,25877' immediate

73 rows selected.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.