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

On your SP5 machines did you previously have a SP3 installed? NT Service Packs should be cumulative but sometimes they aren't. Some changed DLLs with SP3 don't come with SP5 so you need to install SP3 before SP5. I had stability and performance problems on a machine that went from installation directly to SP5. After af fresh install, SP3 and then SP5 the performance and stability is so much better. I think the SP3/SP5 problem is a known issue with OAS 4.0.8.1.

HTH. Finn

John Roberts <robertsj_at_netcomuk.co.uk> wrote in message news:87tse3$222$1_at_taliesin2.netcom.net.uk...
> 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 Sun Feb 20 2000 - 22:49:09 CET