Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can't start second session from same user
Hi!
RESOURCE_LIMIT parameter is an old, very simple way to enforce resource limiting using profile options like CPU_PER_SESSION etc.. Resource manager works independently of this parameter. The parameter affecting which resource manager plan to use, is resource_manager_plan.
Tanel.
"Daniel Roy" <danielroy10_at_hotmail.com> wrote in message
news:1b061893.0304170656.1319ec79_at_posting.google.com...
> I found it! You were right, there was a resource plan which was
> limiting the number of sessions a user could create simultaneously. I
> remove this plan (using dbms_resource_manager), and now the second
> session doesn't hang anymore. What I don't understand is that the
> behavior also happened with resource_limit to FALSE, but that's
> another story. Thanx for your help Connor.
>
> Daniel
>
> >
> > resmgr is resource manager - there may be a plan setup to halt that
> > session in its tracks. Try getting rid of any 'resource_managaer = ' in
> > your init.ora/spfile/etc
> >
> > hth
> > connor
Received on Mon May 19 2003 - 10:15:02 CDT