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: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 17 Apr 2003 09:17:53 +0800
Message-ID: <3E9E00C1.2E63@yahoo.com>


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"
Received on Wed Apr 16 2003 - 20:17:53 CDT

Original text of this message

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