Oracle-L: RE: set sql*trace VB/Crystal

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Mon, 12 Aug 2002 13:08:22 -0800
Message-ID: <F001.004B2313.20020812130822@fatcity.com>

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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Paula_Stankus_at_doh.state.fl.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------