Re: PL/Sql Catreidge Hangs in Web Server 3.0.1 on WIndows nt

Venkatesh Kumar wrote:
<snip>

> Iam running Web Application Server 3.0.1 on Windows NT 4.0 with
> Service Pack 4.0 ( can't run OAS 4.0.7 with sp4).

Not sure about 3.0.1, either - is SP3 a valid w/a until SP5 arrives (haven't we seen this on NT3.51, too?)

> Here is what happens. Sometimes, when invoking the Pl/Sql
> procedure , the Web Server just hangs. When I check the Task
> Manager,it shows that CPU utilization is 100% and that the
> process is sucking up memory. There is lot of paging and
> eventuallt the system goes real low on virtual memory. The
> procedure fails after 15 - 20 minutes that it ran out of memory.

<snip>
It's a bug - the WRB looses sync, and tries to reconnect over and over again, until you run out of memory. Pity you didn't state the version exactly - I think you'll need 3.0.1.0.1
or 3011x.
--
Frank van Bortel

Technical Consultant Oracle
V&L Informatica BV

Work                                Home
Postbus 545                         Hunzestraat 4
7500 AM Enschede                    7555 WB Hengelo
(31)53.434.1500                     (31)74.242.5046