Re: Oracle 817- User Level SQL TRACE

hi from Paris

even coolest:

dbms_system.set_ev('10046',SID,SERIAL#,'12',0)

to put another session in trace mode (even more: event 10046 at level 12)

suggest to read on http://metalink.oracle.Com

for dbms_system specs, and event 10046

"Steve Ashmore" <sashmore_at_neonramp.com> a écrit dans le message de news:vcc3fkdnog045_at_corp.supernews.com...
> You can try to put on a database level trigger to turn on trace for that
> user.
> As sys:
>
> grant execute on dbms_session to cryrptuser;
> create or replace trigger logon_trace_trigger
> after logon on cryrptuser.SCHEMA
> BEGIN
> sys.dbms_session.set_sql_trace(true);
> END;
> /
>
> When you are done drop the trigger.
> Stephen C. Ashmore
> Brainbench MVP for Oracle Administration
> http://www.brainbench.com
> Author of: 'So You Want to be an Oracle DBA?'
>
> "Alex Smith" <SorryNoSpam_at_Please.Com> wrote in message
> news:mHnxa.26021$6L5.11355019_at_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 - 19:06:40 CDT