Oracle Trace facility

From: <Nicolas_VANDECASTEELE_at_bigfoot.com>
Date: Tue, 09 Feb 1999 13:17:11 GMT
Message-ID: <79pcgh$32q$1@nnrp1.dejanews.com>

I am experiencing performance problems in a 7.3.3.3 database on HP-UX and I need to have an event based trace report. Since the ability to add a trace event to a process (with oradbx) is no longer available on 7.3 release, I have to use the new Oracle trace facility on the server (not the OEM interface). TECHNIQUE : dbms_oracle_trace_agent.set_oracle_trace_in session() and format traces in the database with otrcfmt... PROBLEM : Once I have activated a collection with the procedure above, it is not possible to disable tracing by the process. Even if I remove the trace file, it is recreated. It seems to be true only with shadow processes corresponding with non-local connexions (i.e. via SQL*Net).

QUESTION : does anyone have experience with Oracle Trace ?

Thanks to reply to Nicolas_VANDECASTEELE_at_bigfoot.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Feb 09 1999 - 07:17:11 CST