Web application and Oracle session

From: NGUYEN Philippe (Cetelem) <philippe.nguyen_at_cetelem.fr>
Date: Tue, 16 Jul 2002 02:33:20 -0800
Message-ID: <F001.00498E22.20020716023320@fatcity.com>

Hi list !

environment :

userA <-----connexion----->
userB <-----connexion-----> OAS (htp package) <----- 1 session
------> Oracle8i (only 1 application schema)

...	...
userX	<-----connexion----->

A web application is accessed by many users throw OAS which use only one session to access the database.
The application was never tested in multi-user context. The problem now is that the users complain against the slowness of my database (!!)
I test the sql generated by the application and the response-time seems good.

So, my questions are :
- what's append to the Oracle Session when a user A stop his navigator with the "Stop" button while a user B is connected ?

- is it simply a lock problem ?
- is it possible to user several Oracle sessions with OAS ?
- any advices or experiences are welcome : how do you manage sessions in web

application context ?

thankxx in advance
Philippe

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: NGUYEN Philippe (Cetelem)
  INET: philippe.nguyen_at_cetelem.fr

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jul 16 2002 - 05:33:20 CDT