Re: How can I trace SQL executed by forms application
Date: 1996/10/30
Message-ID: <3276b4c5.829462_at_dcsun4>#1/1
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;
dbms_session.set_sql_trace( true );
to start tracing, or you can enable tracing at the instance level by setting the
init.ora parameter:
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
Thomas Kyte
Or
begin
end;
sql_trace=true
>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
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