Raj, Here is a trial run with those procedures... will tell you what those do.
SQL> alter session set sql_trace=true; Session altered. SQL> exec dbms_system.ksdwrt(1, 'From Kirti'); -- Write to trace file (1=Trace, 2=alert, 3=both). PL/SQL procedure successfully completed. SQL> exec dbms_system.ksdddt; -- Add a time stamp to trace file PL/SQL procedure successfully completed. SQL> exec dbms_system.ksdind(30); -- Print ':' upto 30 times (max, I think) in trace file PL/SQL procedure successfully completed. SQL> exec dbms_system.ksdfls; -- Still not found what this does... PL/SQL procedure successfully completed. SQL> alter session set sql_trace=false; Session altered. Look for those in the following trace: ===================== PARSING IN CURSOR #1 len=49 dep=0 uid=0 oct=47 lid=0 tim=3675829616 hv=3932217178 ad='a36d5018' BEGIN dbms_system.ksdwrt(1, 'From Kirti'); END; END OF STMT PARSE #1:c=0,e=1,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=3675829616 >From Kirti <<<<< EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=3675829616 *** 2002-06-20 14:19:46.578 ===================== PARSING IN CURSOR #1 len=32 dep=0 uid=0 oct=47 lid=0 tim=3675830849 hv=2233699027 ad='a36b8990' BEGIN dbms_system.ksdddt; END; END OF STMT PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3675830849 *** 2002-06-20 14:19:46.578 <<<<<< EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=3675830849 *** 2002-06-20 14:19:57.010 ===================== PARSING IN CURSOR #1 len=36 dep=0 uid=0 oct=47 lid=0 tim=3675831893 hv=1989824971 ad='a36bc900' BEGIN dbms_system.ksdind(30); END; END OF STMT PARSE #1:c=1,e=1,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=3675831893 ::::::::::::::::::::::::::::::EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=3675831893 <<<< *** 2002-06-20 14:20:10.772 ===================== PARSING IN CURSOR #1 len=32 dep=0 uid=0 oct=47 lid=0 tim=3675833269 hv=752639005 ad='a36bfc10' BEGIN dbms_system.ksdfls; END; END OF STMT PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3675833269 EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=3675833269 *** 2002-06-20 14:20:21.173 ===================== PARSING IN CURSOR #1 len=34 dep=0 uid=0 oct=42 lid=0 tim=3675834309 hv=1582735206 ad='a3693370' alter session set sql_trace=false END OF STMT PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=3675834309 EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=3675834309 - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
