Tuning Oracle Forms

[Chris Boyle]

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?

[Niall Litchfield]

"Chris Boyle" <cboyle@hargray.com> wrote in message
news:V%Dlb.35054$N94.12471@lakeread02... 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?

It seems to me that you have the right approach already. It looks like there
is either some process happening client side that is taking the 23 seconds
or that the network connection is dodgy, or that you are just sending a lot
of data around the place.

any chance of getting a look at the trace file?


--
Niall Litchfield
Oracle DBA
Audit Commission Uk

[Daniel Morgan]

Chris Boyle wrote:
Forms 6iDatabase 9iv2I have a form that takes 11-23 seconds to open. It uses Oracle graphics butthe 11 seconds is with the graphics background process running. I havegenerated trace files with a 10046 event but it shows most of the hold up assqlnet waiting on more information from the client. Can anyone suggestanother way to approach tuning this form? Is there anything likedbms_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@x.washington.edu
(replace 'x' with a 'u' to reply)

[Chris Boyle]

Thanks. I will have to clear it with the boss but if I can, would you
prefer the trace or the tkprof output?


"Niall Litchfield" <n-litchfield@audit-commission.gov.uk> wrote in message
news:3f97c73a$0$255$ed9e5944@reading.news.pipex.net... "Chris Boyle" <cboyle@hargray.com> wrote in message news:V%Dlb.35054$N94.12471@lakeread02... 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? It seems to me that you have the right approach already. It looks like
there is either some process happening client side that is taking the 23 seconds or that the network connection is dodgy, or that you are just sending a
lot of data around the place. any chance of getting a look at the trace file? -- Niall Litchfield Oracle DBA Audit Commission Uk

[Chris Boyle]

"Daniel Morgan" <damorgan@x.washington.edu> wrote in message
news:1066933308.252370@yasure... Chris Boyle wrote:Forms 6iDatabase 9iv2I have a form that takes 11-23 seconds to open. It uses Oracle graphics
butthe 11 seconds is with the graphics background process running. I havegenerated trace files with a 10046 event but it shows most of the hold up
assqlnet waiting on more information from the client. Can anyone suggestanother way to approach tuning this form? Is there anything likedbms_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@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.