Oracle 10g Express Connection Limitations?
Jason D.
I used Oracle 10g XE a lot last summer and will likely be using it
again this summer. My database is essentially for experiment purposes
and most connections to it are VIA ODBC. I noticed last year after so
many (like 20 perhaps? I'm not sure an exact number) sequential ODBC
connections (that is connect and disconnect, the connections were
*not* concurrent) XE would suddenly refuse more anymore connections
until I restarted the service (running Windows XP). I thought this
might be a limitation of XE but I can't find any documentation on it
as a limitation, so that's making me think it might have been a
problem with my setup. Are there any suggestions on what might be
causing this?
Thanks a Bunch!
yossarian
Keep the V$SESSION dictionary table monitored and you will find out that
the ODBC app doesn't really close the database session.
Y.
Jason D.
Thanks for the reply!
Interesting...is V$SESSION the same as V_$SESSION ? I found the latter
when logging on as "sys" under Views in the Object Browser but
couldn't find one without the underscore.
In any case, it shows 15 tuples all marked as "Active" under Status. I
log on with my ODBC app, and a new tuple pops up showing me with a new
SID, and application info it launched from, etc, but then when I log
off, the tuple (and SID) does indeed disappear. My application calls
SQLDisconnect() and SQLFreeHandle()
when quitting, is there something else I need to do to "close" the
session?
Thanks!
gazzag
> Interesting...is V$SESSION the same as V_$SESSION ? I found the latter
> when logging on as "sys" under Views in the Object Browser but
> couldn't find one without the underscore.
select object_name, object_type
from dba_objects
where object_name in ('V$SESSION','V_$SESSION');
OBJECT_NAME OBJECT_TYPE
------------------------------ ----------------
V_$SESSION VIEW
V$SESSION SYNONYM
Just as an aside, why is your usage of Oracle XE a summer-based
affair? ;)
HTH
-g
Jason D.
It's for a summer research project at university I worked on last
summer and am continuing my research this summer. I'm basically
working on multi-database querying, I've been experimenting mainly
with Oracle, MySQL and Postgres for the time being. I've never used
synonym's before but I googled them to get the basics. I noticed the
owner for V$SESSION is 'public' but I still can't see it in the object
Browser (I can however see it when I log in on the command line/SQL
Plus). So anyway I queried V$SESSION but it didn't tell me anything
new, a extra tuple gets added showing my application connected when it
is, and then the tuple disappears when my application disconnects!
gazzag
> It's for a summer research project at university I worked on last
> summer and am continuing my research this summer. I'm basically
> working on multi-database querying, I've been experimenting mainly
> with Oracle, MySQL and Postgres for the time being. I've never used
> synonym's before but I googled them to get the basics. I noticed the
> owner for V$SESSION is 'public' but I still can't see it in the object
> Browser (I can however see it when I log in on the command line/SQL
> Plus). So anyway I queried V$SESSION but it didn't tell me anything
> new, a extra tuple gets added showing my application connected when it
> is, and then the tuple disappears when my application disconnects!
V$SESSION is a public synonym (as opposed to a private one) and is
therefore potentially visible to all users of the database, providing
that the relevant user has been granted SELECT privilege on the
underlying table, in this case V_$SESSION.
HTH
-g
Jason D.
Ahh, I see, when I log in in SQL Plus I can see the tables, but I
still find it odd that they are not visible in the object browser.