Re: Forms6i SLOW

"Perlie" <perl.news_at_bigfoot.com> wrote in message news:47f51833.0308260709.14d6425f_at_posting.google.com...
> Hi
>
> 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.
>
> 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

You have been misusing forms to implement the functionality of what was in that era called sql*menu. Sql*menu has disappeared since, but no doubt there is equivalent efficient functionality in 6i, which works better than the crap you are using now. Evidently, each new invocation of a form would force NT to spawn a new thread, and a new connection to the database.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address