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: PL/SQL Cartridge - OAS

Re: PL/SQL Cartridge - OAS

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sun, 06 Jun 1999 00:34:41 GMT
Message-ID: <375fc0bc.11099540@newshost.us.oracle.com>


A copy of this was sent to <larry_xu_at_ibm.net> (if that email address didn't require changing) On Sat, 5 Jun 1999 17:04:40 -0400, you wrote:

>Hi
>
>I'm looking for a forum for Oracle Application Server. Can anybody with
>hands-on experience on PL/SQL Cartridge to clarify some of the concept
>regarding the PL/SQL cartridge.
>
>1. Is PL/SQL cartridge stateless by definition?
> Even you try to set min instance > 0 and you won't actually have a session.
>

you won't have a session that is logged in but you will have a connection.

the plsql cartridge is written using a lower level api. It lets them 'connect' to the database but not login. they can login and logout without disconnecting.

When a wrb plsql cartridge is fired up, it does a session level connect to the database. when it gets a request -- it authenticates, does the request and deauthenticates. It does not destroy the connection tho. You can see this by doing a ps on the server and seeing that the dedicated servers are really out there -- select * from v$session won't show them tho.

After the plsql cartridge is started -- no new processes are created for a request. it already has its connection to the database and its dedicated server (or it has been connected to a MTS connection)

>2. If point 1 is correct then, Is following description of
>PL/SQL cartridge TRUE?
>
>Once WRB dispatched the request to PL/SQL Cartridge,
>Cartridge located the DAD and did :
>
>a. Connect the database
>b. Exec the procedure and generate the HTML
>c. DISCONNECT FROM DATABASE IMMEDIATELY
>

its more like this:

during the initialization of the plsql cartridge (its first request) it does a session level connect to the database.

for each request it

when it is shutdown, the plsql cartridges does a session level disconnect from the database.

>That simply means every request need at least a pair of
>Connection/disconnection. Will this overload the server ?
>

no, the auth/deauth is very lightweight when compared to a connect+auth/deauth+disconnect.

>Two OAS books and Oracle document did not explain this clearly. some web sit
>even explain it in just opposite
> http://www.customdb.com/ora_cartridge_facts.html )
>"PL/SQL cartridge provides declarative transactions, persistent connections
>where packages can hold a state, cursors remain open"
>
>Any comment ?
>
>Larry
>
>
>

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Jun 05 1999 - 19:34:41 CDT

Original text of this message

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