Re: OAS 4081 PL/SQL cartridge performs like a dog on NT

Mike,

I don't know about the NT version, but I've installed 4081 on AIX and we had a performance
problem with the wrksf process - taking up most of the cpu and crashing. We fixed this by changing
load distribution scheme ( on the Utilities page under Tuning ) from load based ( the new option ) back to
the min/max scheme. After this, we have 4081 in production use and it runs fine.

Hope this helps

JR

Michael Cretan wrote in message ...
>Hi,
>
>We're using the PL/SQL cartridge of OAS 4.0.8.1 on NT4 (SP5) to access a
>Oracle 8.0.5.0.0 DB on another NT4 (SP6a) box, and despite the fact that
>Oracle claims to have made this product super quick, I'm about to revert to
>OAS 4.0.7.1 due to performance problems.
>
>My problem The first request to the cartridge takes about 10-15 seconds
>before it even accesses the database, then the oraweb40 process goes to
100%
>processor usage for the duration of a request to the DB. Subsequent
requests
>don't have the long initial wait, but the processor usage is still flat
out.
>We're running an Intel PIII 500 with 128MB.
>
>I posted a message last week on this, and heard from 3 or 4 people that had
>similar problems.
>
>My question is this:
>
>a) has anyone had this problem and solved it ?
>or b) has anyone installed OAS4081 on an NT box that is actually as quick
or
>quicker than OAS4071 ?
>or c) is OAS on NT just a sick joke
>
>Many thanks
>
>Mike
>
>------------------------------------------
>Mike Cretan
>Oracle Consultant
>Tasmania, Australia
>email: mcretan_at_ozemail.com.au
>------------------------------------------
>
>
>
Received on Thu Feb 10 2000 - 09:27:03 CET