What connection are they using?
If they are using Oracle Object Of OLE I think there is a parameter that can
be set.
>From: Paula_Stankus_at_doh.state.fl.us
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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: 'ORACLE-L_at_fatcity.com'
>
>
>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: bbaker_at_denvernewspaperagency.com
>
>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: ListGuru_at_fatcity.com (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: fish_dba_at_hotmail.com
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: ListGuru_at_fatcity.com (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).
Received on Mon Aug 12 2002 - 16:58:18 CDT
