Re: Ora 9.2/HPUX 11i/Performance

  • From: "zhu chao" <chao_ping@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 20 Feb 2004 10:31:37 +0800

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@xxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Vergara, Michael
> (TEM)
> Sent: Thursday, February 19, 2004 12:27 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxx]
> 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@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: