Hi,
consider a web application, using BEA between client and an Oracle Database (v9i). BEA is pooling the oracle connections. The oracle database is running in dedicated server mode.
How are the database requests from the web app served by the connection pool from BEA?
1) Does one oracle session serve more than one request simultanously?
2) Or does BEA serialize the requests, which means, that a session from the pool is always serving only one request at a time?
If (1) is true, than an Oracle PL/SQL programmer has the same situation, as with programming an Oracle database in "shared server" mode, that is, he should not use package global variables etc.
Thankful for any ideas...
consider a web application, using BEA between client and an Oracle Database (v9i). BEA is pooling the oracle connections. The oracle database is running in dedicated server mode.
How are the database requests from the web app served by the connection pool from BEA?
1) Does one oracle session serve more than one request simultanously?
2) Or does BEA serialize the requests, which means, that a session from the pool is always serving only one request at a time?
If (1) is true, than an Oracle PL/SQL programmer has the same situation, as with programming an Oracle database in "shared server" mode, that is, he should not use package global variables etc.
Thankful for any ideas...