Michael:
I'm a bit behind in e-mail, but I didn't see that your
question was answered.
Yes, you can turn off a 10046 trace.
How to turn it off depends on how you turned it on:
oradebug event 10046 trace name context off
if you used oradebug
exec dbms_system.set_ev(<sid>,<s#>,10046,0,'');
if you used set_ev
(Note that Oracle frowns on using set_ev, but there
are reasons why sometimes it's the only thing that
works for us.)
Barb
- "Vergara, Michael (TEM)" <mvergara_at_guidant.com>
wrote:
> 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
>
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
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 - 10:35:12 CST