Hi everyone, I have finally updated the paper i wrote about one week ago on the many ways to set trace in Oracle and added quite a lot more information. Thanks to all those who sent me comments and new ideas. It has now more than doubled in size. I have updated quite a bit of the original text and added sections on logon triggers, how to find trace files, how to make them publicly readable, CBO trace, oradebug, setting events in the init.ora, a few more bits and importantly a large section on how to use the new 10G package dbms_monitor for setting trace via sid/serial, client identifier and service/module/action so that end to end trace can be done for multi-tier applications. The paper is available from my web site and is called "How to set trace for others sessions, for your own session and at instance level" it's at http://www.petefinnigan.com/ramblings/how_to_set_trace.htm Hope its of use to some of you. kind regards Pete -- Pete Finnigan email:pete@xxxxxxxxxxxxxxxx Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------