Re: How can I trace SQL executed by forms application

I collected the trace information and ran tkprof to get the report. I did a number of transactions in my application, but the report doesn't show each SQL statement in sequence -- it seems to show each unique SQL statement once with counts indicating how many times it was executed.

I need to get the exact trace in time-sequence (I am going to write a PRO-C program to emulate this series of transactions as part of some analysis I'm going to be doing).

Thomas J. Kyte wrote:
>
> You can use sql trace to get this information.
>
> In a when-new-form trigger you can put:
>
> begin
> forms_ddl( 'alter session set sql_trace=true' );
> end;
> Or
> begin
> dbms_session.set_sql_trace( true );
> end;
>
> to start tracing, or you can enable tracing at the instance level by setting the
> init.ora parameter:
> sql_trace=true
>
> You will then run tkprof to get a report of all sql.
>
> You should have timed_statistics enabled in the init.ora file if you are doing
> performance tuning. This will let you see how long the statements took to
> parse, open, fetch, etc. in addition to seeing the statements themselves.
>
> On Tue, 29 Oct 1996 10:53:29 -0500, Steve Rothkin <srothkin_at_nynexst.com> wrote:
>
> >Is there any way I can capture a log/trace of ALL the SQL executed by an
> >Oracle Forms 4.5 application (both what I have in my triggers and what
> >is done automatically by forms)?
> >
> >--
> > Steve Rothkin NYNEX Science and Technology
> > email: srothkin_at_nynexst.com Room T5
> > voice: (914) 644-5211 400 Westchester Avenue
> > fax: (914) 644-2153 White Plains, NY 10604
>
> Thomas Kyte
> Oracle Government
> tkyte_at_us.oracle.com
>
> http://govt.us.oracle.com
>
> ---- Check out Oracle Governments web site! -----
> Follow the link to "Tech Center"
> and then downloadable Utilities for some free software...
>
> -------------------
> statements and opinions are mine and do not necessarily
> reflect the opinions of Oracle Corporation
 

-- 
 Steve Rothkin                NYNEX Science and Technology
 email: srothkin_at_nynexst.com  Room T5
 voice: (914) 644-5211        400 Westchester Avenue
 fax:   (914) 644-2153        White Plains, NY  10604