Re: Orphan sessions
From: gonzo <gbahut_at_ravenpack.com>
Date: Thu, 23 Jun 2011 00:43:11 -0700 (PDT)
Message-ID: <9256eb48-2785-4dc7-aad4-91664898eb59_at_l18g2000yql.googlegroups.com>
Try cleaning up idle sessions automatically from the server side using db_resource_manager.
Date: Thu, 23 Jun 2011 00:43:11 -0700 (PDT)
Message-ID: <9256eb48-2785-4dc7-aad4-91664898eb59_at_l18g2000yql.googlegroups.com>
Try cleaning up idle sessions automatically from the server side using db_resource_manager.
You can specify directives to to terminate idle sessions belonging to any specific user. You specify this by setting KILL_SESSION as the switch group using the resource plan directive MAX_IDLE_TIME: Maximum idle time for the session.
Info here: http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/dbrm.htm#i1010776 Received on Thu Jun 23 2011 - 02:43:11 CDT