RE: 10046 Trace Pronunciation

  • From: "Cary Millsap" <cary.millsap@xxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 11 Aug 2004 23:11:53 -0500

That's easy: it's pronounced "extended SQL trace". The following names =
will
live for at least the next decade:

- 10046 level 1 <=3D> SQL trace
- 10046 level 4 <=3D> SQL trace with binds
- 10046 level 8 <=3D> SQL trace with waits
        ..."waits" is the wrong word, but we're stuck with it.
- 10046 level 12 <=3D> SQL trace with binds and waits

You see, with the advent of DBMS_SUPPORT.START_TRACE*(..., =
waits=3D>true,
binds=3D>true), we're not supposed to talk about--or even know =
about--event
10046 anymore (which, by the way, is of course pronounced "ten thousand
forty six").

By the time Oracle version 10 is in production in 75%+ of Oracle =
customer
sites (2010 by my estimation), the fact that extended SQL trace had an =
event
code at all--much less that the number was 10046--will be a distant =
memory,
a little piece of trivia whose only virtue will be to prove that the =
person
remembering it is too old to think flexibly or function in the modern =
job
market. We'll have become those dinosaurs who used to refer to assembler
instructions by their hexadecimal op-codes instead of their eminently =
more
user-friendly three-character mnemonics.


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *

Upcoming events:
- Performance Diagnosis 101: 8/10 Boston, 9/14 San Francisco, 10/5 =
Charlotte
- SQL Optimization 101: 7/26 Washington DC, 8/16 Minneapolis, 9/20 =
Hartford
- Hotsos Symposium 2005: March 6-10 Dallas
- Visit www.hotsos.com for schedule details...


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Lee Lee
Sent: Wednesday, August 11, 2004 8:52 AM
To: oracle-l
Subject: 10046 Trace Pronunciation

Hi Gurus,

When explaining to another person that I am going to
do a 10046 trace what is the best why to say it?

"For performance tuning I like to do a one, zero,
zero, four, six trace."

"For performance tuning I like to do a one hundred,
forty-six trace."

"For performance tuning I like to do a ten, Oh,
forty-six trace"

Thank you!


        =09
__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
----------------------------------------------------------------
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: