Re: Oracle 817- User Level SQL TRACE
Date: Sat, 17 May 2003 09:12:55 -0500
Message-ID: <TJednS_uYZb13lujXTWcqA_at_texas.net>
Turn traces on at the client's desk.
"Alex Smith" <SorryNoSpam_at_Please.Com> wrote in message
news:lJnxa.26034$6L5.11359457_at_news4.srv.hcvlny.cv.net...
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.
> Some of the Reports (developed using CRYSTAL REPORTS) does not perform
well.
> We always launch all the reports as Oracle User = 'CryRptUser' . I would
> like to trace the SQL Statements that is being forwarded by Crystal
Reports
> 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.
>
>
Received on Sat May 17 2003 - 16:12:55 CEST