Forms6i SLOW

[Quoted] [Quoted] We have problems with an application under Oracle Forms 6i running on WinNT Clients / Solaris DB. What works reasonably well at the start of a session slows down to a mere crawl. This is regarding forms navigation and the displaying of the data which both are VERY slow after sometimes only half an hour, sometimes after a couple hours.

The application was originally created under Forms 3 and ported to Forms 6i. It has a starting form, from which the user chooses the actual form he wants to work with. The form of his choice is then run with CALL / CALL_QUERY (Forms 3), CALL_FORM (Forms 6i) respectively. When the user has finished with the form the control is passed back to the starting form (with EXIT_FORM) from where he chooses the next form to work with etc.

This all worked very well under Forms 3. However under Forms 6i things slow down after 20-30 times changing to a different form. In this state while scrolling in a multi-row block the individual lines of data temporarily disappear, you can only see the background of the form. Only after releasing the key/mouse does the data appear again. Etc. Etc.

[Quoted] When the Forms session is terminated and a new session is started, performance is once again OK. The client itself does not need to be rebooted. In the Windows Task Manager everything looks fine, no memory problems, no cpu load during and at the end of the forms session. We have inspected V$OPEN_CURSOR for a leak there but not found any indication for it.

Has anybody got some advice apart from changing the application structure (calling of other forms)?

Thank you in advance.

Perl News Received on Tue Aug 26 2003 - 17:09:23 CEST