Re: Uregent help needed

From: Kresimir Fabijanic <kresimir_at_ozemail.com.au>
Date: Tue, 10 Nov 1998 23:17:04 +1100
Message-ID: <36482EBF.B7C83254_at_ozemail.com.au>

Farjaad

These tips are Oracle or Forms related not a general ( like use timing etc ) or design related.

1 - For Forms use generated fmx, for pll libraries use plx and for reports generate rep files. They will be quicker to load.

Tune all database access related SQL statements using SQL*Plus - Explain plan and TKPROF (You may use other tools available on the market - Sylvan Faust's SQL Programmer, Quest's - SQL Lab, Platinum's SQL Station etc). Also you can trace your form sessions (and push trace files through TKPROF) to see what SQL your Forms are issuing against the database.

2 - There is debugger in Forms - execute Form from within the debugger. (Turn the debugger option to run the file from designer [there is a button with little bug on the left hand side])

3 - Matrix reports

There are more tips.  Check Mark Gurry & Peter Corrigan's 'Oracle Performance
Tuning'  There is whole section 'Tuning for Programmers', also there are
chapters 'Tuning in the Client Server Environment' and 'Tuning Oracle Forms 4.0

and 4.5' also Guy Harrison's book is good for SQL tuning.

Kresimir Fabijanic

farjaad wrote:

> Hi
>
> I have just taken a course in oracle(dev/2000) and looking for job I have
> been to a couple of interviews, I would like to know how best you can reply
> to the following most common questions asked :
>
> 1) What steps would you take to fine tune the application during
> developement and afterwards
>
> 2) How best would you debug your application
>
> 3) What could be the most complicated report in report 2.5
>
> Your best answers to above questions will greatly help me to get a job
> quickest possible
>
> Thanks
>
> Farjaad
Received on Tue Nov 10 1998 - 13:17:04 CET