RE: Ora 9.2/HPUX 11i/Performance

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Fri, 20 Feb 2004 07:54:44 -0600
Message-ID: <022401c3f7b9$1baa9380$6b01a8c0@CVMLAP02>

Any time you see the term "sql_trace", it refers to 10046 level 1. So the difference is:

dbms_system.set_sql_trace_in_session -- level 1 only dbms_support.start_trace_in_session -- you specify the level you want

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
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of zhu chao Sent: Thursday, February 19, 2004 8:32 PM To: oracle-l_at_freelists.org
Subject: Re: Ora 9.2/HPUX 11i/Performance

hi, Cary:

Is the difference only whether it can early enable detailed 10046? Or
there is still other difference?

Thanks

Zhu Chao.

Original Message ----- From: "Cary Millsap" <cary.millsap_at_hotsos.com> To: <oracle-l_at_freelists.org> Sent: Friday, February 20, 2004 4:03 AM Subject: 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
> - SQL Optimization 101: 2/16 Dallas
> - Hotsos Symposium 2004: March 7-10 Dallas
> - Visit www.hotsos.com for schedule details...
>
>
> -----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
> > ---
> > =
>

=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3
> D=
> 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D
> > =
>

=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3
> D=
> 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D
> > =
>

=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3
> D=
> 3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D
> >=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
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
> ----------------------------------------------------------------
> 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
-----------------------------------------------------------------

----------------------------------------------------------------
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 Fri Feb 20 2004 - 07:54:44 CST