Timing procedures in SQL*Forms

We have an SQL*Forms 3.0 application running in a UNIX environment on a Sun Platform. One form in particular is experiencing very slow response times when more then 1 or 2 users are running it. The form has some complex PL/SQL procedures that we know are causing the problem. We are waiting for an upgrade to the kernal that Oracle assures us will correct the problem. In the mean time, we would like to optimize the procedures as much as possible. To do this, we must find a way to record the time it takes to perform the set of procedures within SQL*Forms. We can not just pull out the procedures and run them in SQL*Plus using the timing option because the processing is dependent on the form.

Can anyone recommend a way of timing a series of procedures within SQL*Forms?

Please send e-mail responses to alex.alexander_at_oit.gatech.edu

Thanks

-- 
Jean McSpadden 
Georgia Institute of Technology, Atlanta Georgia, 30332
uucp: ...!{allegra,amd,hplabs,seismo,ut-ngp}!gatech!prism!iadt1jm
ARPA: iadt1jm_at_prism.gatech.edu