I detected the sid and serial# from v$session then exec sys.dbms_system.set_bool_param_in_session(sid=>sid,serial#=>serial#,parnam=> 'timed_statistics',bval=>true); then exec sys.dbms_system.set_int_param_in_session(sid=>sid,serial#=>serial#,parnam=>' max_dump_file_size',intval=2147483647); sys.dbms_system.set_ev(sid,serial#,10046,12,''); thats it the resulting trace file shows till set_ev and nothing of the traced session. Thanks Deep ----- Original Message ----- From: "Jamadagni, Rajendra" <Rajendra.Jamadagni@xxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Monday, April 26, 2004 4:08 PM Subject: RE: Unable to do a 10046 trace on another users session > It would help us if you showed what you 'typed' ... Or the script that > you used. > > Raj > ------------------------------------------------------------------------ > --------=20 > Rajendra dot Jamadagni at nospamespn dot com=20 > All Views expressed in this email are strictly personal.=20 > select standard_disclaimer from company_requirements;=20 > QOTD: Any clod can have facts, having an opinion is an art ! > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Arghadeep Chatterjee > Sent: Monday, April 26, 2004 6:18 AM > To: oracle-l@xxxxxxxxxxxxx > Subject: Unable to do a 10046 trace on another users session > > Hi All, > I am trying to trace another users session (10046 trace) by using > DBMS_SYSTEM as mentioned in Cary's book my problem is though everything > runs out fine the resulting trace file only shows the last line of my > current SQL and doesnt report any SQL of the application I am trying to > trace.I am enabling the trace form SQLPLUS while the application is > Oracle Forms 6i.Any ideas the steps I have followed is exact replica of > one shown in hotsos.Thanks Regards Arghadeep Chatterjee DBA "KSPL" > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- > > > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------