|
Good
question. I see it very intermittently with sessions (robot cells) that
stay connected for days on end. Just had an occurrence this week.
The DB has been up for 96 days before all heck broke loose. Thankfully we
only need to reconnect/restart the robots.
Dick Goulet -----Original Message-----
From: Sam Bootsma [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 4:50 PM To: Multiple recipients of list ORACLE-L Subject: RE: Limiting Concurrent Sessions Not Working Hi Dick, Thanks for the tip. Metalink says the bug applies to RDBMS 8.0.4. I tested it as well, using a modified version of their test case. I did not encounter this bug at all.
Perhaps it is OK on Oracle 7.3.4?
-----Original
Message-----
OK, now watch out for Oracle bug 643709 which can send your users a pile of "ORA-02394: exceeded session limit on IO usage, you are being logged off" even though you don't have any IO limits set. It's fixed in 8.1.x.
Dick Goulet -----Original
Message----- Bingo!
Thanks Dick, it is working now.
Sam GBC
-----Original
Message-----
Do you have "resource_limit = true" in init.ora? If you don't it defaults to FALSE & the profile has no effect.
Dick Goulet -----Original
Message----- Oracle7 Server Release 7.3.4.5.0 (yes, I know, old); AIX 4.3.3
Hello All,
I am trying to limit concurrent sessions on my database. The Oracle documentation says I can do it. However, when I follow the steps (create profile with sessions per user set to one, then assign Oracle user to this profile) the user is not stopped from exceeding the number of concurrent sessions. I tested this by connecting using Sql Plus. I even tried bouncing the database, to see if that makes a difference, but to no avail.
Any ideas what is happening? Am I missing something? Is this a problem/bug with Oracle 7.3.4? The output below shows the steps I followed to create the profile and user. It also shows multiple connections to the database after bouncing the instance.
Thanks for any suggestions!
Sam.
SQL> create profile sam limit sessions_per_user 1;
Profile created.
SQL> create user sam identified by sam;
User created.
SQL> alter user sam profile sam;
User altered.
SQL> grant create session to sam;
Grant succeeded.
SQL>
SQL> l 1 select limit 2 from dba_profiles 3 where profile='' 4* and resource_name = 'SESSIONS_PER_USER' SQL> /
LIMIT ---------------------------------------- 1
SQL>
SQL> select profile 2 from dba_users 3 where username = 'SAM';
PROFILE ------------------------------ SAM
SQL>
SVRMGR> shutdown normal Database closed. Database dismounted. ORACLE instance shut down.
SVRMGR> connect internal Connected to an idle instance. SVRMGR> startup ORACLE instance started. Total System Global Area 34122296 bytes Fixed Size 38992 bytes Variable Size 31797736 bytes Database Buffers 2252800 bytes Redo Buffers 32768 bytes Database mounted. Database opened. SVRMGR> select osuser, username 2> from v$session; OSUSER USERNAME --------------- ------------------------------ oracle oracle oracle oracle oracle oracle oracle oracle oracle oracle oracle oracle SYS 12 rows selected. SVRMGR> select osuser, username from v$session; OSUSER USERNAME --------------- ------------------------------ oracle oracle oracle oracle oracle oracle oracle oracle oracle oracle oracle oracle SYS sam SAM sam SAM 14 rows selected. SVRMGR>
Sam GBC
|
- Limiting Concurrent Sessions Not Working Sam Bootsma
- RE: Limiting Concurrent Sessions Not Working Goulet, Dick
- RE: Limiting Concurrent Sessions Not Working Sam Bootsma
- RE: Limiting Concurrent Sessions Not Working Goulet, Dick
- RE: Limiting Concurrent Sessions Not Working Goulet, Dick
- RE: Limiting Concurrent Sessions Not Working Sam Bootsma
