create or replace procedure kill_session
is
sql_stmt varchar2(300);
s1 VARCHAR (150);
 s2 VARCHAR (150);
 cursor my_curr is select  sid,serial#  from V$SESSION
        where      status='INACTIVE' AND
                    TO_CHAR(SYSDATE,'MI') - TO_CHAR(LOGON_TIME,'MI') >=60;
   begin
    OPEN my_curr;
  FETCH my_curr
   INTO s1,s2;
  WHILE my_curr%FOUND
  LOOP  
  execute immediate ('alter system kill session '''||s1||','||s2||'''');
      FETCH my_curr
      INTO s1,s2;      
  END LOOP;
end;   

DECLARE
JobNo NUMBER;
v_date date;
BEGIN
 dbms_job.submit(JobNo, 'begin kill_session; end;', SYSDATE,
'(sysdate + 3600/(24*60*60))');
 COMMIT;
END;

Begin
DBMS_JOB.REMOVE(job_number)
commit;
end;
/

Sun Dec 16 10:50:30 2007
Process P072 died, see its trace file
Sun Dec 16 10:50:30 2007
Process startup failed, error stack:
Sun Dec 16 10:50:30 2007
Errors in file c:\oracle\product\10.2.0\admin\vnp\bdump\vnp_psp0_2260.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
ORA-27301: OS failure message: Overlapped I/O operation is in progress.
ORA-27302: failure occurred at: skgpspawn

Sun Dec 16 10:50:31 2007
Process P071 died, see its trace file
Sun Dec 16 10:50:31 2007
Process startup failed, error stack:
Sun Dec 16 10:50:31 2007
Errors in file c:\oracle\product\10.2.0\admin\vnp\bdump\vnp_psp0_2260.trc:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
ORA-27301: OS failure message: Overlapped I/O operation is in progress.
ORA-27302: failure occurred at: skgpspawn

sga_max_size                         big integer 1504M
sga_target                           big integer 1504M
db_cache_size=1249902592
java_pool_size=16777216
large_pool_size=33554432
shared_pool_size=268435456
streams_pool_size=0

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------
max_shared_servers                   integer     20
shared_server_sessions               integer
shared_servers                       integer     10
SQL> show parameter dispatcher

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------
dispatchers                          string      (protocol=TCP)(disp=15)
max_dispatchers                      integer     25
SQL>

NAME                                 TYPE        VALUE
------------------------------------ ----------- -------
pga_aggregate_target                 big integer 501M
SQL>