Re: Profile on RAC

I think you may be at a current limitation. I've experienced the same challenge with resource manager and active sessions. If you use a service then you can direct all users to a single node, enforcing the "global" policy by forcing a "logon" instance, but I don't know if you use load balancing then.

On 2/26/08, Oliver Jost <Oliver.Jost_at_ca.fujitsu.com> wrote:
> I have a 2 node cluster on which I have a profile given to all
> users... under normal circumstances the user is limited to 3 concurrent
> sessions (previously on our standalone). Unfortunately, it seems that the
> profile is limited per node and the users can have 6 concurrent sessions if
> the load balancer passes them to the second node... Without handling the
> number of sessions programmatically... am I missing something? I would
> ultimately like to restrict the number of sessions globally (i.e. regardless
> of instance on the cluster the user should be restricted to 3 sessions).

-- 
Regards,

Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l