RE: Ora 9.2/HPUX 11i/Performance

From: Vergara, Michael (TEM) <mvergara_at_guidant.com>
Date: Thu, 19 Feb 2004 10:26:38 -0800
Message-ID: <791D0E1ECDECD04D89205F33806FC38701E91BCE@temmse06.tem.guidant.com>

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

Received on Thu Feb 19 2004 - 12:26:38 CST