Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Ora 9.2/HPUX 11i/Performance
Don't use dbms_system.set_sql_trace_in_session; use
dbms_support.start_trace_in_session. Big difference. The dbms_support
one lets you catch waits and binds. The dbms_system one doesn't. See
"How to activate extended SQL trace" at
http://www.hotsos.com/e-library/index.html for details.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 2/24 San Diego, 3/23 Park City, 4/6 Seattle
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Vergara, Michael
(TEM)
Sent: Thursday, February 19, 2004 12:27 PM
To: oracle-l_at_freelists.org
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 > We are having intermittent and irregular performance issues > with one of our home-grown reports from our SAP system. I tried > running a SQL trace, but it was insufficient to our needs. >=20 > Is there another kind of trace that I can turn on and turn off > that will supply more info about the SQL, the execution plan, and > access times? >=20 > Thanks, > Mike >=20 >=20 > --- > =
>=20 > Michael P. Vergara > Oracle DBA > Guidant Corporation >=20 > ---------------------------------------------------------------- > 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
-- 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 - 14:03:59 CST
![]() |
![]() |