1 Reply Latest reply on Jul 1, 2017 3:43 PM by mdtaylor

    Using Resource Manager to automatically kills idle blocking sessions in EBS R12.1

    Ali_1900

      Hi there,

       

       

      As per below Oracle Note:

      Using Resource Manager to Detect and Kill Idle Sessions (Doc ID 1557657.1)

       

      We need to configure Resource Manager as follows to kill blocking sessions which are idle for more than 10 minutes:

      begin

        dbms_resource_manager.create_pending_area;

        dbms_resource_manager.create_plan(

          plan => 'idle_mgmt_plan2',

          comment => 'Detects and kills idle sessions');

        dbms_resource_manager.create_plan_directive(

          plan => 'idle_mgmt_plan2',

          group_or_subplan => 'other_groups',

          max_idle_blocker_time => 600,

          comment => 'Limits idle time for blocking sessions to 10 minutes ');

        dbms_resource_manager.submit_pending_area;

      end;

      /

       

      My question is whether it is safe to do in EBS R12.1 environment?

       

      Seeking quality responses.

       

      Thanks.

        • 1. Re: Using Resource Manager to automatically kills idle blocking sessions in EBS R12.1
          mdtaylor

          I am pretty confident if you implement this as written you will find yourself restarting the applications frequently to get the login page to work.  There is a lot of JDBC connection pooling and you may even kill some concurrent managers waiting for something to do.

           

          What is safe to do is kill self blocking forms sessions from the back end.  If a user locks a row and is disconnected, when they go back to complete their work the shadow process form their earlier session is usually still holding the same row, and they create a blocking lock trying to resume their work.  The original blocker will generally never clear itself so they are safe to kill.