Re: Web Application Server, PL/SQL, Dynamic Web Page

Hi Michelle !

How much memory allocates this process ?? up to 30MB or more ?

We have the problem that we get sometimes zombies on the machine. process up to 130MB !!
We are using webserver 3.0.1.8.0 on AIX 4.2.1. This is a bug ! Oracle is working on a patch! This same error occured under NT.

Br Manfred

Michelle Warner <delonda_at_radium.ncsc.mil> wrote in article <34DB1A18.88B8405B_at_radium.ncsc.mil>...
> I am working with Web Application Server 3.0 and Oracle 7. I am
> constructing a dynamic web page via a stored procedure which makes a
> call to owa_util.tablePrint to retrieve the data from the database.
> However, my data never returns and the process appears to be hung and I
> must kill it. Here is the section of code which is causing me problems:
>
> htp.tableOpen('border');
> more_data := owa_util.tablePrint('drawtabl', 'BORDER',
> OWA_UTIL.PRE_TABLE, 'dwgnum, dwgtit, dwgtyp','where dwgnum = srch4',
> 'Number, Title, Type');
>
> I connect to the database using a DAD and an Agent. Any
> help/suggestions would be greatly appreciated. Thanks in advance
>
>
> Michelle
>
>
>
>
Received on Fri Feb 06 1998 - 00:00:00 CST