RE: Ora 9.2/HPUX 11i/Performance

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

Can you turn off a 10046 trace?

-----Original Message-----
From: Daniel W. Fink [mailto:Daniel.Fink_at_Sun.COM] Sent: Thursday, February 19, 2004 9:56 AM To: oracle-l_at_freelists.org
Subject: Re: Ora 9.2/HPUX 11i/Performance

10046 level 12. Check out www.hotsos.com for settings and how to read = the file.

"Vergara, Michael (TEM)" wrote:

> Hi Everyone!
>
> 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.
>
> 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?
>
> Thanks,
> Mike
>
> ---
> =

=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
>
> Michael P. Vergara
> Oracle DBA
> Guidant Corporation
>
> ----------------------------------------------------------------
> 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:59 CST