RE: Sessions
Date: Wed, 3 Jun 2009 15:33:35 -0400
Message-ID: <DB508580748FAD4692628A58C4E653F506C56781_at_MAIL01.Corp.FC.LOCAL>
Thanks for the input everyone. I'm hoping to minimize the hit against any global view to control parallel query processes. The logons on a relatively slow day can hit 20,000+ ... I've got a few ideas and will take into consideration what I've received so far.
Thank you,
Oliver
- The information in this e-mail message including any attachment is intended only for the named recipients above and may contain confidential information. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by replying to the message and deleting all copies of it from your computer. **
From: Andrew Kerber [mailto:andrew.kerber_at_gmail.com]
Sent: Wednesday, June 03, 2009 11:12 AM
To: Oliver Jost
Cc: oracle-l_at_freelists.org
Subject: Re: Sessions
You can always set up log on triggers with just about any conditions you care to name. Do some checking upon log in, and if certain criteria is met (or not met), just kill the session.
On Wed, Jun 3, 2009 at 12:54 PM, Oliver Jost <Oliver.Jost_at_ca.fujitsu.com> wrote:
Hi All,
I run a RAC environment with a profile limitation of 3 sessions set. Unfortunately, RAC uses the profile on an instance basis... that is, a user can open 3 connections per instance. The application I run is going to come under some heavy fire in the coming year because we will be running a third node with a substantial growth in user base ( 6000 - 7000 concurrent users). The application is a forms/reports application. I'm trying to come up with a few options on tighter control of user sessions. I can't really play with the profile limitations because load balancing may hit the same node and refuse another session if the balancer tries to run a report off an instance that has reached the maximum allowable sessions. I'd be appreciative of any ideas you may have.
Thank you,
Oliver
- The information in this e-mail message including any attachment is intended only for the named recipients above and may contain confidential information. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by replying to the message and deleting all copies of it from your computer. **
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 03 2009 - 14:33:35 CDT