Re: How can I trace SQL executed by forms application
Date: 1996/10/30
Message-ID: <3276b4c5.829462_at_dcsun4>#1/1
[Quoted] 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
- 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 Received on Wed Oct 30 1996 - 00:00:00 CET