I am going to risk the wrath of Jarad to suggest that maybe we could say that a 10046 level 1 is a Cary 1, a 10046 level 4 is a Cary 4 etc. Similarly we could designate a 10053 level x as a Wolfgang x. This would have meaning to all DBA's and leave others scratching their heads but not wanting to seem stupid, agreeing. Over and out, Ruth -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Cary Millsap Sent: Thursday, August 12, 2004 12:12 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: 10046 Trace Pronunciation 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------