Re: 100% CPU Forms 4.5 Oracle 7.3.4

[Quoted] On 12 Nov 2001 02:26:56 -0800, lb38bc_at_yahoo.de (Christian Baar) wrote:

>We are running a Forms 4.5 application using Oracle 7.3.4 (AIX) and
>caught a terrible client behaviour since we installed a new component
>doing some sort of batch processing:
>
>For every item of a list of records we load a form, do some
>processing, unload the form and continue with the next record.
>
>This works fine for a list containing a very small number of records
>(2, 3, etc). When we do this with a larger amount of records (60 or
>more), the processing works fine, too, but after the last record is
>processed, the client's CPU load remains at 100% for about 10 minutes,
>although nothing is done (at least by the client-side code).
>Unnecessary to say that even the processing of a mouse-click takes
>forever during this time :-(
>
>Has anybody ever experienced something like this and is able to help
>me out?
>
>Christian

First of all : both 7.3.4 and Forms 4.5 have been desupported quite a while ago. You will soon find yourself stuck. Secondly: from your description it looks like you start a new form many times, involving connect and disconnect, and server side session for each individual connect. If that is true it is not amazing it doesn't work, as you will rapidly consuming all resources. Other than that the description of your problem is very vague (how do you manage to load a form for every item in a list of records? Forms is not suited for batch processing) and you request us to shoot in the dark

regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Nov 12 2001 - 12:39:58 CET