Re: How to activate all traces ...

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Mon, 26 Aug 2002 19:51:03 +1000
Message-ID: <mDma9.15340$g9.48436@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 - 04:51:03 CDT