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

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Server Profiler = Oracle ??

Re: SQL Server Profiler = Oracle ??

From: Brian Peasland <oracle_dba_at_peasland.com>
Date: Thu, 3 Oct 2002 17:29:53 GMT
Message-ID: <3D9C7E91.902413FB@peasland.com>


Why not issue:

ALTER SESSION SET SQL_TRACE=TRUE; Then run your query. Then issue:

ALTER SESSION SET SQL_TRACE=FALSE; A trace of that query will be found in USER_DUMP_DEST.

HTH,
Brian

Fernando Ibarra wrote:
>
> Hi,
>
> Somebody knows since I can make a trace of one query in Oracle. I can do
> it in SQL Server, but I do not know the tool that allows to do it in Oracle.
>
> Trank.
Received on Thu Oct 03 2002 - 12:29:53 CDT

Original text of this message

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