Re: Newbie trace question

In article <8t97gh$a7i$1_at_nnrp1.deja.com>,   CUJimmy <public_at_asd-group.com> wrote:
>
> > > However, it is NOT in DBMS_UTILITY, but in DBMS_SESSION. This
>
> But this approach wouldnt work for me with my need to be able to
> monitor the SQL generated by a standalone, one-shot (ie. it runs, gets
> data from the database, and ends) console program like the one I have
> to analyse....would it??
>
> Apologies in advance if this is a stupid question, but as the title
> says this is all deep and murky water to me :-)
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

You are correct, this is a procedure that would need to be executed by the stand-alone application after connecting to the instance and before doing any data processing. To ensure that you would capture this applications SQL in a trace file so it could be analyzed by tkprof you will need to set the 'sql_trace' init<SID>.ora parameter and restart the instance. You will also need to remember to disable this in the init<SID>.ora file once you have generated enough trace to accomplish your goal.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.