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: Ana C. Dent <anacedent_at_hotmail.com>
Date: Wed, 14 Jul 2004 01:22:31 GMT
Message-ID: <Xns9525BAEBA15DESunnySD@68.1.17.6>


edward.mcmonagle_at_ntu.ac.uk (Ed_Zep) wrote in 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.

Alternatively, run the *trc file generated thru TKPROF & make sure to use EXPLAIN=username/password qualifier Received on Tue Jul 13 2004 - 20:22:31 CDT

Original text of this message

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