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: Oracle Trace

Re: Oracle Trace

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 13 Jul 2006 09:26:08 -0700
Message-ID: <1152808301.496441@bubbleator.drizzle.com>


Papa Piquillo wrote:
> Paul:
> When the user logs and before running the report you have to activate
> the trace for the user. You have to query in v$session the sid ,
> serial# for the user and then execute as sys
>
> dbms_system.set_sql_trace_in_session ( sid , serial# , true)
>
> After this you have a .trc file in user_dump_dest with the trace for
> the user.
> Run the report or whatever you want to trace and then execute
>
> dbms_system.set_sql_trace_in_session ( sid , serial# , false)
>
> to deactivate the trace.
> Then is time to analyze the trace with tkprof. You can run
>
> tkprof file_in_user_dump_dest.trc trace.txt record=trace.sql
>
> and you get a record of all the sql statements in the file trace.sql.
> You can have a look at trace.txt for more information.
> Hope this helps.
> Bye.

Another possibility is to install the DBMS_SUPPORT built-in package documented in Morgan's Library at www.psoug.org.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Jul 13 2006 - 11:26:08 CDT

Original text of this message

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