Re: Wish to trace using 10046 or 10053

You can enable them in a login trigger. If that is not good enough you can enable them like any event in the init.ora. It is probably not too big a deal for the 10053 event trace, but enabling 10046 system wide will trace everything, including smon and pmon. I've "heard" people say that the smon 10046 trace is very illustrative if you want to learn more about Oracle's internal workings, but I believe there are also warnings/bug reports about 10046-tracing pmon on metalink.

Paula_Stankus_at_doh.state.fl.us wrote:
> However, for those traces you need sid and session and we specifically
> wish to trace a login. Can you enable 10046 or 10053 for an entire
> database? Is there a way to do this?
>
> Thanks,
> Paula
>

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l