Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can't start second session from same user

Re: Can't start second session from same user

From: Tanel Poder <tanel_at_@peldik.com>
Date: Mon, 19 May 2003 18:15:02 +0300
Message-ID: <3ec8f40b$1_1@news.estpak.ee>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US