select distinct(sql_id),OPNAME,sid,SERIAL#  from v$session_longops where sofar != totalwork and time_remaining>0 and OPNAME ='Sort Output';

create table temp_longops as select distinct(sql_id),OPNAME,sid,SERIAL#  from v$session_longops where sofar != totalwork and time_remaining>0 and OPNAME ='Sort Output';

select SERIAL#,sid,state from v$session where sql_id in (select distinct(sql_id) from v$session_longops where sofar != totalwork and time_remaining>0 and OPNAME ='Sort Output' );

select 'alter system kill session ''(||sid,SERIAL#||')'  from v$session_longops where sofar != totalwork and time_remaining>0 and OPNAME ='Sort Output';

select a.state from v$session a,temp_longops b where a.sql_id=b.sql_id;

select 'alter system kill session '''||sid||','||SERIAL#||''';' from temp_longops;

alter system kill session '1265,27141';

alter system kill session '354,7053';

alter system kill session '807,17451';

alter system kill session '1581,41715';

alter system kill session '4893,23';

alter system kill session '2483,12035';

alter system kill session '2742,20461';

alter system kill session '281,34515';

alter system kill session '3925,14451';

alter system kill session '2911,8695';

alter system kill session '4221,14531';

alter system kill session '787,36285';

alter system kill session '4436,19227';

alter system kill session '25,57755';

alter system kill session '2105,31275';

alter system kill session '451,16259';

alter system kill session '3475,47561';

alter system kill session '3078,35245';

alter system kill session '3181,22695';

alter system kill session '2036,49463';

alter system kill session '621,25583';

alter system kill session '2947,8127';

alter system kill session '4986,24129';

alter system kill session '954,37155';

alter system kill session '1020,697';

alter system kill session '1712,9505';

alter system kill session '5312,61639';

alter system kill session '432,29873';

alter system kill session '4315,57623';

alter system kill session '3879,46481';

alter system kill session '4750,25347';

alter system kill session '3722,59543';

alter system kill session '617,5747';

alter system kill session '690,9737';

alter system kill session '4271,25631';

alter system kill session '439,8431';

alter system kill session '2744,28857';

alter system kill session '3851,29623';

alter system kill session '2171,61211';

alter system kill session '4397,11519';

alter system kill session '3250,61731';

alter system kill session '562,14817';

alter system kill session '1853,29163';

alter system kill session '100,47653';

alter system kill session '5179,27265';

alter system kill session '1963,14933';

alter system kill session '4348,50923';

alter system kill session '1942,65383';

alter system kill session '1319,9267';

alter system kill session '1325,16861';

alter system kill session '717,52975';

alter system kill session '4975,9421';

alter system kill session '2065,23281';

       SID    SERIAL#

---------- ----------

alter system kill session '647,18473';

alter system kill session '4089,60027';

alter system kill session '1431,13079';

alter system kill session '2917,54287';

alter system kill session '2669,14137';

alter system kill session '4122,28789';

alter system kill session '808,61661';

alter system kill session '1896,12117';

alter system kill session '4601,4497';

alter system kill session '3537,64227';

alter system kill session '3892,27767';

alter system kill session '2801,28557'; 

select 'alter system kill session '''||sid||','||SERIAL#||''';'  from v$session_longops where time_remaining>0 and OPNAME ='Sort Output';

select a.state from v$session a,v$session_longops b where b.time_remaining>0 and b.OPNAME ='Sort Output' and a.sql_id=b.sql_id;

select distinct(sql_id),OPNAME,sid,SERIAL#  from gv$session_longops where time_remaining>0 and OPNAME ='Sort Output';