Re: Forms 3 problem??
Date: 08 Feb 1995 08:19:08 GMT
Message-ID: <OLLI.RINNE.95Feb8101908_at_titi-uu.tte.vtt.fi>
bernie_at_eve.adam.com.au (bernie rossi) wrote:
> Has anyone experienced slow startup times for Forms3 forms started with
> runform30 (or sqlforms30 for that matter)?
We have forms with 34000 lines. Normally startup times are not a problem.
The problem might be Forms column security checking. We had a form with over 10 blocks and tables. With lot of defined users it's startup slowed down remarkably. Tracing the form displayed very slow SELECTs from the Oracle's table-access tables (ALL_TAB_GRANTS etc).
Our solution was to add owner-information to blocks basetables (at blocks definition 'TABLE = SCOTT.EMPLOYEE'). After that SELECTs could use indexes on those access checks and startup time went back to normal. Other solution would have been to disable column security.
I suggest that you should enable database tracing, run your runform with -s -option and analyse results with TKPROF. If it shows up some slow fetches at startup, try to analyse those with EXPLAIN.
olli R Received on Wed Feb 08 1995 - 09:19:08 CET