Re: OAS 4081 PL/SQL cartridge performs like a dog on NT
From: Leo Van Nieuwenhuyse <leo.van.nieuwenhuyse_at_pandora.be>
Date: Tue, 08 Feb 2000 20:57:48 GMT
Message-ID: <gr%n4.2693$am2.11288_at_afrodite.telenet-ops.be>
Date: Tue, 08 Feb 2000 20:57:48 GMT
Message-ID: <gr%n4.2693$am2.11288_at_afrodite.telenet-ops.be>
I installed it on A PIII 450 - 128 MB, (I must admit on a SP4, not a SP6a) and it works fine and quick! Even with a 8.0.5 database running on the same machine. I'll test it out with another 8.0.5 over sqlnet.
-- ----------------------------------------------------- Click here for Free Video!! http://www.gohip.com/freevideo/ Michael Cretan <mcretan_at_ozemail.com.au> schreef in berichtnieuws sCHn4.20549$3b6.87471_at_ozemail.com.au...Received on Tue Feb 08 2000 - 21:57:48 CET
> 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
> ------------------------------------------
>
>
>