after this fire this sql
select * from ( select ss.value, sn.name, ss.sid from v$sesstat ss, v$statname sn where ss.statistic# = sn.statistic# and sn.name like '%opened cursors current%' order by value desc) where rownum < 11 ;
and use alter system kill session
select sid, status, event, seconds_in_wait state "wait(s)" , blocking_session "blk_sesn", prev_sql_id "SQL_ID" from v$session where sid=<SID-Number>;
Is there any other way to manually kill the inactive cursors which are still being displayed.