Re: Memory Leak in Oracle Forms

Are you closing all the cursors that you are using in that form's PL/SQL?

-Matt

"Toine Tuerlings" <su007675_at_wolmail.nl> wrote in message news:8i2jt8$cie$1_at_nereid.worldonline.nl...
> We came across a memory leak while doing a benchmark for 1000 users in the
> following environment:
>
> OAS 4.0.7
> Developer Server 6
> AIX 4.3
>
> Situation is:
>
> Start the application
> Look at memory using command "ps v <f60runm process number>"
>
> Open a form (using OPEN_FORM)
> Open a form (using CALL_FORM)
> Retrieve some data
> Close form
> Retrieve some data
> Close form
>
> Repeat the last 6 steps 10 times
> Look at memory using command "ps v <f60runm process number>"
>
> It will show that every time you repeat this procedure the memory that your
> runform process has allocated increases. When running 1000 of these
> processes our memory will run out for sure.
>
> Has anyone done measurements like these?
> Does anyone use the same configuration?
>
> Oracle support have reproduced the problem and is trying to fix it. What do
> we do in the meantime?
>
> Regards Toine Tuerlings.
>
>
>
Received on Mon Jun 12 2000 - 00:00:00 CEST