Re: Performance Issue with OAS 4.0.7

You should be able to do better than 25-35 seconds! The initial cartridge server startup is slow, but after that it should be quick. To do this up front, under your application / configuration /server screen, make sure cartridge timeout isn't too low, and set min # of servers to 1 or higher. If you set min and max instances to 5 and 20, you also must set min and max threads to 5 and 20. These 2 sets of parameters must match for the plsql cartridge to work right (even though the default installation doesn't set it up this way!).

Venkatesh Kumar wrote:

> Hi guys,
> I finally got the Oracle Web Server OAS 4.0.7 to work with Windows NT
> 4.0 (with SP4). I had to install te Patch to make it work with SP4.
> However, the response really sucks. The PL/Sql Catridge takes almost
> 25-35 seconds before it comes back with a response. The next time around
> it is fine. It is fine as long as Iam calling a procedure. If there is
> break in the call to a procedure it takes the 25-30 seconds for a
> response.
>
> I have changed the default Catrridge config parameters and bupmed the
> minimum number of instances to 5 and max to 20. also I have changed the
> client session to 5. But it still makes no difference.
>
> Any suggestions on what else I need to do. My frined tells me that the
> documentation mentions that the performance of a standalone OAS server
> will be slower than if it is running off a server. I find it hard to
> believe.
>
> Appreciate any help anyone can provide.
>
> Cheers
> Ven Kumar
Received on Tue Apr 20 1999 - 05:50:26 CDT