Carmen, Just put the 10046 trace and sql in a file and set term off. eg. alter session set events '10046 trace name context forever, level 8'; set term off select whatever from whereever; exit; HTH Jared oracle-l-bounce@xxxxxxxxxxxxx wrote on 05/19/2004 11:34:01 AM: > I am running an 10046 event trace from sqlplus for a query which returns > a lot of rows to the terminal. > > How can I suppress the output by another method than autotrace > traceonly? ( so that my trace file doesnt show all that extra processing > from autotrace) > > Thanks, > Carmen Rusu > Oracle DBA ---------------------------------------------------------------- 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 -----------------------------------------------------------------