Implementation of the Windows operating system kill Oracle threads ____oracle

implementation steps:

1. Change init parameter resource_limit to true; restart the database;

2. Change the "Idle connection Time" of profile profiles for user profiles;

3. In the database query session state is "Snipe", through the operating system Orakill command to clear;

4. Define the Windows execution plan and execute the Kill_session_sql.bat script.

Script:

Kill_session_sql.bat content:

Set ORACLE_SID=ORA9/** Database instance sid**/

Sqlplus system/oracle@ora9 @c:kill_session.sql

C:kill_session.bat

Kill_session.sql content:

Spool C:kill_session.bat

Set head off

Set Feedback off

Set PageSize 1000

Set term off

COLUMN EVENT FORMAT A30

Select ' Orakill ora9 ' | | P.spid | | ' From V$process p, v$session s Where p.addr = s.paddr and status = ' sniped ' and s.username are NOT null;

Spool of

Exit