Good morning everyone: Since everyone was wondering what the Top 10 things were from IOUG Live!, I went to the source: Ian Abramson, Director of Educational Programming for the IOUG and the person that provided this jocularity. Here they are:
Here is the top 10 list: Top 10 Lessons Learned at IOUG Live 2002 >From the home office in Chicago, IL 11. (added during speech) If you go to Tijuana don't drink the water 10. Scott Tiger is real! 9. Finding ways to bring humor into your workday does not mean laughing after doing a shutdown abort on your production database .... by mistake. 8. Kellogg's may have a Mini-Wheat, but the IOUG has a Mini-Dean 7. It is possible to print an onsite agenda on the head of a pin or grain of rice. 6. SQL*Net = The dollar amount derived by subtracting the money generated by owning Oracle from the cost of the license. 5. You will find your way around the Convention Center not later than Thursday afternoon 4. San Diego is colder than Canada 3. Hashing is not illegal 2. In the brain of the DBA. "Session 504 has been moved to room 30A" means "alter session 504 move tablespace 30A" And the #1 thing I learned at IOUG Live 1. IOUG Live Sandwiches are made by Oracle .... you can't break in! Ian Abramson Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -----Original Message----- Sent: Wednesday, April 24, 2002 7:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n no, the Tijuana trip we were very careful not to drink the water (hm, that left only alcohol!) I just didn't write them down, was having too much fun just listening to them --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > >> I don't remember the rest > > Was that because of the water in Tijuana?? :-)) > Sorry I missed out on that, but I got otherwise > involved in something. > > RF > > -----Original Message----- > Sent: Wednesday, April 24, 2002 3:28 PM > To: Multiple recipients of list ORACLE-L > please > n > > > One I know was "bring a coat to San Diego" > > for those of you not at IOUG, San Diego, a city that is supposedly > warm > was COLD and everyone was freezing there > > they added a "zero" -- when you go to Tijuana, don't drink the water" > > I don't remember the rest > > > --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > > So, do you remember the other top 10 items?? > > > > Robert > > > > -----Original Message----- > > Sent: Wednesday, April 24, 2002 11:39 AM > > To: Multiple recipients of list ORACLE-L > > please > > n > > > > > > it was also mentioned at the Oracle of Oracles closing session, in > > the > > "top 10 things I learned in San Diego" :) > > > > > > --- Cary Millsap <[EMAIL PROTECTED]> wrote: > > > Might have been Dave too, but I mentioned it in my > > "Misunderstandings > > > About Oracle Internals" talk at IOUG on Tuesday... > > > > > > > > > Cary Millsap > > > Hotsos Enterprises, Ltd. > > > [EMAIL PROTECTED] > > > http://www.hotsos.com > > > > > > > > > -----Original Message----- > > > Sent: Monday, April 22, 2002 10:58 PM > > > To: Multiple recipients of list ORACLE-L > > > n > > > > > > I think it was Dave Ensor... > > > > > > ----- Original Message ----- > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > Sent: Monday, April 22, 2002 6:30 PM > > > > > > > > > > Hi Connor, > > > > > > > > Somebody (I think it was Cary) mentioned your little PL/SQL > > > procedure > > > that > > > > will provide any required CHR. So you are famous, even if you > > were > > > not > > > > present :) > > > > > > > > And yes, without seeming to migrate to the CHR camp, there is > > some > > > merit > > > in > > > > what you are saying. However, I would suggest that tracking > > > 'normal' > > > delta > > > > values of 'cache buffer chain' gets, misses, spins and sleeps > > from > > > > V$SYSTEM_EVENT/V$LATCH, as well as deltas of 'table scan rows > > > gotten' > > > vs > > > > 'table fetch by rowid' would be a better 'ratio' than the CHR > > which > > > will > > > > only serve to feed a myth. The former would give you some > > > indication > > > of > > > LIO > > > > (and the stress it causes on the system) and the latter will > > > indicate > > > raw > > > > requirements that were met but were the ones that drove PIO.... > > As > > > for > > > me, > > > I > > > > detect changes in the following SQL and page out to an on-call > > DBA > > > when > > > some > > > > set limits are exceeded: > > > > > > > > select event, count(*) from v$session_wait > > > > group by event; > > > > > > > > This does show the 'current' bottleneck and I still remain true > > to > > > the > > > > calling of OWI!! > > > > > > > > John Kanagaraj > > > > Oracle Applications DBA > > > > DBSoft Inc > > > > (W): 408-970-7002 > > > > > > > > Grace - Getting something we don't deserve > > > > Mercy - NOT getting something we deserve > > > > > > > > Click on 'http://www.needhim.org' for Grace and Mercy that is > > > freely > > > > available! > > > > > > > > ** The opinions and statements above are entirely my own and > not > > > those > > > of > > > my > > > > employer or clients ** > > > > > > > > > > > > > -----Original Message----- > > > > > From: Connor McDonald [mailto:[EMAIL PROTECTED]] > > > > > Sent: Monday, April 22, 2002 4:44 PM > > > > > To: Multiple recipients of list ORACLE-L > > > > > Subject: RE: Anything new from IOUG? + "OWI" Born!! > > > > > (Anjo/Mogens, please > > > > > n > > > > > > > > > > > > > > > I still like to recommend the buffer cache hit ratio > > > > > because its so easy to please customers with an > > > > > improvement - A plsql routine to generate any desired > > > > > hit ratio on a running system is freely available for > > > > > download from my site... a consultants dream! :-) > > > > > > > > > > But, serious hat on temporarily, there IS still a use > > > > > for the buffer hit ratio as a "delta" measurement. > > > > > What I mean by this is that you measure it every 'n' > > > > > mins/hrs/whatever and store it. When it displays a > > > > > massive dip or a massive increase (ie something out of > > > > > the ordinary for *your* system), then whilst it > > > > > doesn't necessarily mean anything is wrong - it DOES > > > > > mean that something has changed in your system, which > > > > > is a good prompt to do some investigation.. > > > > > > > > > > hth > > > > > connor > > > > > > > > > > --- John Kanagaraj <[EMAIL PROTECTED]> wrote: > > > > > > Mark, > > > > > > > > > > > > This is from a first-timer at IOUG, so I may be way > > > > > > off here. > > > > > > > > > > > > A lot of marketing blurb was thrown out at IOUG > > > > > > (probably a lot less than > > > > > > usual, and *much* less than Oracle OpenWorld in any > > > > > > case!). As for tools, > > > > > > many vendors were flogging the same ones, improved > > > > > > versions maybe. One which > > > > > > did make us say 'wow' was StorageXpert from Quest. > > > > > > IMHO, this is an > > > > > > excellent tool, engineered by our very own Gaja. I > > > > > > believe details are at > > > > > > the Quest site at www.quest.com. If you have EMC > > > > > > disks and are facing > > > > > > performance problems, I believe there is the best > > > > > > there is. (Or even if you > > > > > > have other storage devices, it would still give you > > > > > > the hotspots). > > > > > > > > > > > > And NO, I do NOT work for Quest, nor have Quest > > > > > > stock! > > > > > > > > > > > > And for others, I believe this was a major turning > > > > > > point and an eye-opener > > > > > > as far as the Wait Interface goes (This has > > > > > > (un)officially been renamed to > > > > > > OWI as per Kirti's slides :-). Most attendees 'saw > > > > > > the light' as far as CHR > > > > > > (Cache Hit Ratio) goes, and there were two distinct > > > > > > camps after the first > > > > > > few days - the 'CHR' and 'OWI'. No prizes for > === message truncated === __________________________________________________ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
