Oracle 817- User Level SQL TRACE

From: Alex Smith <SorryNoSpam_at_Please.Com>
Date: Sat, 17 May 2003 09:58:49 GMT
Message-ID: <tJnxa.26037$6L5.11360159@news4.srv.hcvlny.cv.net>

Hey Guys,
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 - 04:58:49 CDT