| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Ora 9.2/HPUX 11i/Performance
Michael,
If this is a long running SQL statement, and you start the trace while the
statement
is executing, there's a good chance you won't see it in a trace file.
Gary Goodman or Cary Millsap wrote some details here about it recently.
In any case, you could always turn 10046 trace on for all sessions, run
your
job, then turn the tracing off.
HTH Jared
"Vergara, Michael (TEM)" <mvergara_at_guidant.com>
Sent by: oracle-l-bounce_at_freelists.org
02/19/2004 10:26 AM
Please respond to oracle-l
To: <oracle-l_at_freelists.org>
cc:
Subject: RE: Ora 9.2/HPUX 11i/Performance
Using the SAP tools, we can isolate the process that is
running (at least instantaneously) SQL that we're interested
in. I then use...
begin
sys.dbms_system.set_sql_trace_in_session( &sid, &serial, TRUE);
end;
/
...to trace that session. If we could not find it, you're absolutely correct that we'd have to turn tracing on globally, and then walk over 400 trace files looking for SQL of interest. NOT how I want to spend my day!
Cheers,
Mike
-----Original Message-----
From: Jared Still [mailto:jkstill_at_cybcon.com]
Sent: Thursday, February 19, 2004 10:10 AM
To: Oracle-L Freelists
Subject: Re: Ora 9.2/HPUX 11i/Performance
When you say 'sql trace' do you mean 10046?
Which session(s) did you trace? =20
As SAP users get their data through an application server, I would suspect you would need to turn tracing on for all SAPR3 connections.
Jared
On Thu, 2004-02-19 at 09:41, Vergara, Michael (TEM) wrote:
> Hi Everyone!
>=20
>=20
>=20
>=20 >=20
>=20
>=20> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Feb 19 2004 - 16:07:13 CST
 |
 |