[Q] Multi Threaded Server - Performance issues

We have Oracle 7.1.3 on HPUX and are trying to simulate approx. 400 client connections via MTS.

We have noticed that once a client has CONNECTed, the first PL/SQL packaged procedure call (NOT SELECT or UPDATE) may take 3 to 4 seconds to complete. Subsequent calls of the same type run very fast. eg. 0.1 seconds

Whereas, if we run the exact same code via a dedicated connection, all of the calls made are in the 0.1 sec. or better range.

Has anyone else seen this behaviour?
Any thoughts on this would be greatly appreciated.

MTS - Sizing the SGA

Oracle 7 Server Administraor's Guide page 4-3 notes that for each user who will connect using the MTS, add 1K to the setting of the parameter SHARED_POOL_SIZE. Our feeling is that this is nowhere near enough.

Does anyone have any rules of thumb for estimating the amount of memory for the SGA when MTS is used?
(Keep in mind that a dedicated connection seems to require about 700K)

Thanks for your help,

Tony Cook Received on Wed Mar 22 1995 - 23:44:14 CET