Re: OAS 4081 performance problems to tear your hair out with!!

I have experienced the exact same problem running Oracle 8.1.5 (8i) on the same machine as the 4.0.8.1 web server. The machine also has SP5. I have been searching for the answer for this for quite some time and have been unsuccessful. I find it hard to believe that many other people have not noticed this (unless we're doing something really wrong). If anyone knows the answer to this, please let us know.

Thanks,

Kevin.

"Michael Cretan" <mcretan_at_ozemail.com.au> wrote in message news:phnm4.17693$3b6.74012_at_ozemail.com.au...
> Hi there,
>
> I'm going insane trying to get to the bottom of this problem...
>
> We have installed OAS 4.0.8.1 on a windows NT box running SP5.0, which is
> accessing a database on another NT machine running SP6.0, and an Oracle
> 8.0.5.0.0 database.
>
> We are using the PL/SQL cartridge to provide data from the database and
> return it to the users, with the default Oracle web listener
>
> My problem is that while the request is being serviced by OAS the
processor
> usage of the oraweb40
> (I assume this is the international 40-bit encryption version) goes to
100%
> and stays there until the request has been serviced by the database. As
the
> database uses dbms_alert to wait for information from a legacy system, the
> duration can be quite some time. however all the time that this is
> happening, the webserver is going red in the face doing god knows what.
>
> Another issue is that the when a web request is the first to come through
in
> a while (say 5 minutes) it takes 10 - 15 seconds to even process the
request
> and begin to access the database.
>
> I've tried to tweak the tuning parameters and the tuning model, but even
if
> I start 5 instances of the PL/SQL cartridge, it still 'goes to sleep'
after
> five minutes.
>
> Has anyone encountered any of these problems?
>
> Is OAS4081 fit to go into production like this ?
>
> Thanks in advance.
>
> Mike
>
> ------------------------------------------
> Mike Cretan
> Oracle Consultant
> Tasmania, Australia
> mcretan_at_ozemail.com.au
> ------------------------------------------
>
>
>
>
Received on Fri Feb 04 2000 - 20:13:48 CET