Re: Oracle 817- User Level SQL TRACE

GT Jeff Cherer wrote:
> Turn traces on at the client's desk.
> About 3-4 lines in your sqlnet.ora. It's pretty well documented.
> Also, look at an odbc trace, depending on how you get your reports. If you
> are window$, it in the control panel odbc manager.
>
>
> "Alex Smith" <SorryNoSpam_at_Please.Com> wrote in message
> news:lJnxa.26034$6L5.11359457_at_news4.srv.hcvlny.cv.net...
>

>>Hey Guys,
>>Some of the Reports (developed using CRYSTAL REPORTS) does not perform

>>We always launch all the reports as Oracle User = 'CryRptUser' .  I would
>>like to trace the SQL Statements that is being forwarded by Crystal

>>to Oracle.
>>
>>Can we turn on SQL-TRACE for a specific Oracle user.  I don't want to turn
>>Trace ON at  the database level.
>>
>>Thanks for your help.
>>
>>

That would be network tracing, not server. Check out the "alter session" syntax on how to enable tracing for a session - can be done in two ways: from within that session, or from another session, e.g. a monitoring tool.

-- 
Regards, Frank van Bortel