Re: Can't start second session from same user

From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 17 Apr 2003 07:56:42 -0700
Message-ID: <1b061893.0304170656.1319ec79@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 Thu Apr 17 2003 - 09:56:42 CDT