Re: Can't start second session from same user

Daniel Roy wrote:
>
> Hi everyone,
> I'm running Oracle 9.2.0.1 EE on Windoze 2000 Server (Pro). I
> created a first session as SCOTT/TIGER, and issued 'create table
> onlyoneitl (id number primary key, anyjunk varchar2(20)) tablespace
> users initrans 1 maxtrans 1;", and "insert into onlyoneitl values (1,
> 'bla-bla');", and never committed this insert. Then, I tried to create
> a second session with same user SCOTT/TIGER, but SQL*Plus just hangs.
> I know it's not Windows having a hard time creating a dedicated
> thread, since I was afterwards able to connect as SYSTEM. If I look in
> V$SESSION_WAIT, I see that the hanging session has EVENT =
> "resmgr:waiting in run (queued)", for which I can't find any info. I
> know that the table can have only 1 ITL entry, and it's taken, but I
> thought that it would hang only if I try to acquire a second lock from
> the second session (by inserting a new record in the new table, for
> example), not if I just try to login. Anyone has an idea what's going
> on?
>
> 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

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"