Re: How to activate all traces ...

Richard's right.

You do know it's possible to force another session into trace don't you ? using DBMS_SYSTEM. something it's not in the manuals but it's been posted here many times.

anyway hi everyone I'm back from holiday nice to see you all again.... "Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:mDma9.15340$g9.48436_at_newsfeeds.bigpond.com...
> Hi again Epicentre,
>
> Depends on what you want to do.
>
> First question I would ask you is why would you want to trace all user
> sessions. Are you aware of the repercussions of doing so, especially with
> large numbers of users.
>
> Secondly, are you aware of what Oracle Trace is used for. Do you know how
to
> turn on a trace collection (eg. the ORACLE_TRACE_COLLECTION_NAME
parameter)
> ? What are you planning to do with this information ?
>
> The fact you want to globally turn on "tracing" make me suspicious on what
> it is you are trying to accomplish.
>
> Cheers
>
> Richard
> "Epicentre team A" <oracle_at_epicentre.fr> wrote in message
> news:akck7u$473$1_at_wanadoo.fr...
> > Hi
> >
> > oracle_trace_enable =TRUE and trace_sql=TRUE in my init<sid>.ora
> > Is there others parameters for others traces ?
> >
> > Thanks
> > Epicentre Team A
> >
> >
>
>
Received on Mon Aug 26 2002 - 06:30:02 CDT