RE: 10046 tracing in PRO C programs?
I have seen this when I have created a logon trigger which activates trace but the owner of the trigger did not have ALTER SESSION granted directly to it (instead it was through a role). Sessions logging on ended up creating a trace file but nothing was in it but "TRACE DUMP CONTINUED FROM FILE" - Ethan -Original Message- Sent: Thursday, May 22, 2003 5:18 PM To: Multiple recipients of list ORACLE-L Glenn, I think the "TRACE DUMP CONTINUED FROM FILE" message occurs because file is actually opened by the SET TRACEFILE_IDENTIFIER command, and then "re-opened" by the SET EVENTS command. I see this all the time, except that after the "***" line, there's a whole trace file full of stuff. Please forgive me if the following question seems impertinent (you seem to well know what you're doing)... Are you sure that in your test situation, your code actually makes database calls that should show up in your trace data? Aside from that, you can try leaving out the SET TRACEFILE_IDENTIFER out and seeing what happens. This will at least get rid of the "TRACE DUMP CONTINUED FROM FILE" message. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Reykjavik, Ottawa, Dallas, Washington, Denver, Sydney - Visit www.hotsos.com for schedule details... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: 10046 Tracing ...
Title: RE: 10046 Tracing ... Anyone else used trcanlzr.sql to advantage? There's lot's of PL/SQL in it. -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 6:25 AM To: Multiple recipients of list ORACLE-L Subject: Re: 10046 Tracing ... On Wed, Jan 29, 2003 at 11:24:07AM -0800, Jamadagni, Rajendra wrote: > Has anyone used > ftp://oracle-ftp.oracle.com/apps/patchsets/AOL/SCRIPTS/PERFORMANCE/TRCA.zip > yet? I found it today and seems to be a nice utility. Sweet ... and it works > even if you are not running Oracle apps. nice metalike article on it: TRCANLZR.sql - Trace Analyzer Interpreting Raw SQL Traces generated by EVENT 10046 Carlos Sierra Apps Engineering Team Oracle Support January 2003 === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED]
Re: 10046 Tracing ...
On Wed, Jan 29, 2003 at 11:24:07AM -0800, Jamadagni, Rajendra wrote: > Has anyone used > ftp://oracle-ftp.oracle.com/apps/patchsets/AOL/SCRIPTS/PERFORMANCE/TRCA.zip > yet? I found it today and seems to be a nice utility. Sweet ... and it works > even if you are not running Oracle apps. nice metalike article on it: TRCANLZR.sql - Trace Analyzer Interpreting Raw SQL Traces generated by EVENT 10046 Carlos Sierra Apps Engineering Team Oracle Support January 2003 === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
10046 Tracing ...
Title: 10046 Tracing ... Has anyone used ftp://oracle-ftp.oracle.com/apps/patchsets/AOL/SCRIPTS/PERFORMANCE/TRCA.zip yet? I found it today and seems to be a nice utility. Sweet ... and it works even if you are not running Oracle apps. It is probably a better tkprof interface, but intuitive ... cool tool !! Just thought I'd share with you all. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2