What connection are they using? If they are using Oracle Object Of OLE I think there is a parameter that can be set.
>From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: set sql*trace VB/Crystal >Date: Mon, 12 Aug 2002 13:08:23 -0800 > >If you want to see the trace do the following connected to the appropriate >database: >SQL> show parameters dump; > >NAME TYPE VALUE >------------------------------------ ------- ------------------------------ >background_core_dump string partial >background_dump_dest string /opt/oracle/admin/ods/bdump >core_dump_dest string /opt/oracle/admin/ods/cdump >max_dump_file_size string UNLIMITED >shadow_core_dump string partial >user_dump_dest string /opt/oracle/admin/ods/udump > >I believe it is under user_dump_dest - and is constrained by the >max_dump_file_size. > >You will then need to use tkprof commands to format *.trc file. To check >it >is correct trace file can grep session id or even bit of SQL she used that >would be specific to her session. > >Most of the Oracle references have tkprof examples, so does metalink and >cdrom with oracle doc. > >-----Original Message----- >Sent: Monday, August 12, 2002 4:03 PM >To: '[EMAIL PROTECTED]' > > >I don't know vb either. However the trace file is likely generated on the >server-side. She would not see the output. She might want to try alter >session set autotrace on; instead. That way she should see the results. >That is how it works in SQL*PLUS. Otherwise, you will have to send her the >trace file from the server - you guys will get quickly tired of that. >'AUTOTRACE ON' does have some limitations/bugs where it doesn't necessarily >show you - but I believe that is related to partitioning and parallelism. > >-----Original Message----- >Sent: Monday, August 12, 2002 4:23 PM >To: Multiple recipients of list ORACLE-L > > > >List: >We have a crystal report performing badly. (No! ,you say. You're shocked!) >The report has a visual basic front end. > >Our developer wants to set sql trace in the VB code. It's not working. >When I tkprof her trace file, all that's in there is the "ALTER SESSION SET >SQL_TRACE TRUE" command. > >Is there some trick here? I don't know VB at all, so I don't know how to >advise her. She looked on the Microsoft site, but it was not helpful. > >Thanks for any help! > >Barb > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Baker, Barbara > 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). _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade 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).
