Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tracing SQL Statements Behind a Form

Re: Tracing SQL Statements Behind a Form

From: Joel Garry <joel-garry_at_home.com>
Date: 13 Jul 2004 17:37:18 -0700
Message-ID: <91884734.0407131637.613e0aea@posting.google.com>


edward.mcmonagle_at_ntu.ac.uk (Ed_Zep) wrote in message news:<4e489625.0407130508.5220d598_at_posting.google.com>...
> Hello.
>
> Can anyone please tell me the best way to trace the SQL goings-on
> behind the scenes of a form?
>
> I'm not after tuning information, just the actual SQL being run.
>
> I've tried execute sys.dbms_system.set_ev (sid,serial#,10046,8,'');
>
> which gives a lot of information that I'm not looking for (e.g.
> waits).
>
> Is there a way of getting just the SQL?
>
> Many thanks.
>
> Ed McMonagle.
> UK.

OEM has show SQL. One way is to go into top sessions and click on your desired session. Explain plan there too.

There's some scripts floating about, see http://www.jlcomp.demon.co.uk/guilty.html for one. Might find some clues here, too: http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=131704.1&blackframe=0

jg

--
@home.com is bogus.
http://www.newsoftheweird.com/special/special.html
Received on Tue Jul 13 2004 - 19:37:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US