Re: Tuning Oracle Forms

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1066933308.252370_at_yasure...
> Chris Boyle wrote:
>
> >Forms 6i
> >Database 9iv2
> >
> >I have a form that takes 11-23 seconds to open. It uses Oracle graphics
but
> >the 11 seconds is with the graphics background process running. I have
> >generated trace files with a 10046 event but it shows most of the hold up
as
> >sqlnet waiting on more information from the client. Can anyone suggest
> >another way to approach tuning this form? Is there anything like
> >dbms_profiler for forms?
> >
> >
> >
> Is the form doing a SELECT * FROM a very large table or is it opening to
> a single record?
>
> Use can use SET_BLOCK_PROPERTIES to get a single record
> also consider
> Set_Block_Property('<block_name>',OPTIMIZER_HINT,'FIRST_ROWS');
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>

Thank you, i will check. I inheirited this form so i don't know the settings right off. Received on Fri Oct 24 2003 - 01:26:54 CEST