RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
that too I found that after I finished eating lunch, there was almost as much in "garbage" (inedible food) left in the lunch box as there was in "food" when I opened the box. The potato chips were usually good though :) --- Brian McGraw <[EMAIL PROTECTED]> wrote: > >>1. IOUG Live Sandwiches are made by Oracle you can't break in! > > UnBreakable, InEdible. > > Brian > > -Original Message- > Stephen > Sent: Thursday, April 25, 2002 9:03 AM > To: Multiple recipients of list ORACLE-L > n > > 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 > > > >
RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
>>1.IOUG Live Sandwiches are made by Oracle you can't break in! UnBreakable, InEdible. Brian -Original Message- Stephen Sent: Thursday, April 25, 2002 9:03 AM To: Multiple recipients of list ORACLE-L n 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,
RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
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 '
RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
hi Mike, Go to my site (www.oracledba.co.uk), then Tuning => Custom Hit Ratio Enjoy! Cheers Connor --- "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> wrote: > Ok...ok...ok...enough talk... can somebody PLEASE > publish a > reference location of this script? > > Thanks, > Mike > > > -Original Message- > Sent: Wednesday, April 24, 2002 8: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
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 ** > > > > >
RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
>> 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 rati
RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, 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
RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
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
RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
Ok...ok...ok...enough talk... can somebody PLEASE publish a reference location of this script? Thanks, Mike -Original Message- Sent: Wednesday, April 24, 2002 8: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 S
RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, 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.
RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
Mogens, I bet Oracle would call it "OWIi". As Micro$oft is appending XP to everything, Oracle puts an "i" to everything. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Tuesday, April 23, 2002 9:58 PM To: Multiple recipients of list ORACLE-L please n It's so very cool to see the phrase catching on in 2002. Thanks, Kirti. I think the OWI thing just might become common. Now let's see what Oracle comes up with wrt naming standards on something which is quite unique... Mogens ***1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
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 day
Re: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
Way back when ships were made of wood and men of steel, I saw the phrase "The Wait Interface" in an internals class written by members of the COE of Oracle Support - specifically the Wait Interface was a phrase used (perhaps invented?) by Roderick Manalack, who's still an honored member of the Oracle community inside the Oracle firewall. So I started using the phrase "The Wait Interface" when doing presentations all over the world. This was back when Lex de Haan ran the Technical Seminar show. Must have been back in 1996 or so, right Lex? It's so very cool to see the phrase catching on in 2002. Thanks, Kirti. I think the OWI thing just might become common. Now let's see what Oracle comes up with wrt naming standards on something which is quite unique... Mogens Deshpande, Kirti wrote: >John & all, > I just used the term, OWI. I do not claim to be the originator of this >term. But I like it very much. > > As for the ratios go, I did not use the 'R' word(s) ;) in my short >presentation. It was, however, mentioned in the session abstract to get >attention. > > My sincere thanks to all who attended my presentation. > > Regards, > >- Kirti > >-Original Message- >Sent: Monday, April 22, 2002 5:24 PM >To: Multiple recipients of list ORACLE-L >n > > >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 guessing who won the day! The >massive number of defections and the absolute absense of >CHR-based-discussions at the Performance round tables was clear evidence >that OWI is here to stay! (Mr. R might still rewrite that book sooner than >later!) > >About 20 Listers met for dinner on Sunday night (and again in a larger group >at the SeaWorld bash). The meeting was characterized by geek-talk such as >'Can you fit us all in one extent?' i.e. 'can we all sit at one table?'), >'Please coalesce' - 'please move in so that more people can fit into the >aisle seats'. > >Oh Boy, that WAS a lot of fun! > >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: Mark Leith [mailto:[EMAIL PROTECTED]] >>Sent: Monday, April 22, 2002 4:58 AM >>To: Multiple recipients of list ORACLE-L >>Subject: Anything new from IOUG? >> >> >>Hi All that recently attended IOUG. >> >>If you don't already know - I sell "tools" for Oracle. >>(delete this now if >>you want to DG! ;P) >> >>I was just wondering if anybody at IOUG had any feedback on >>any "new" tools >>that were launched, or any tools that made a significant >>impact at IOUG? >> >>This is purely for "vendor awareness" for myself, as I like >>to keep up to >>date on anything new in and around our particular market >>place.. If anybody >>saw something and thought "wow!", I'd be interested in >>hearing about it. If >>you would like to contact me directly about this - please >>feel free, though >>I feel the list *could* also benefit from this.. >> >>Cheers >> >>Mark >> >>=== >> Mark Leith | T: +44 (0)1905 330 281 >> Sales & Marketing | F: +44 (0)870 127 5283 >> Cool Tools UK Ltd | E: [EMAIL PROTECTED] >>=== >> http://www.cool-tools.co.uk >> Maximising throughput & performance >> >> >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: Mark Leith >> 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 PROTEC
Re: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
Respect! We might have to move from the basic "Ratios suck" idea to "Bad Ratios" and "Good Ratios" ideal. One good ratio: R = S + W Mogens Don Granaman wrote: There is one ratio that is a far better indicator than any of that fancywait analysis stuff - the USR (User Satisfaction Ratio). I usually considerthe system to be optimal if the USR is near 97% (the other 3% are chronicwhiners anyway). Of course, this does not apply if the CEO is in that 3%.Any CEO waits are considered unacceptable.Don Granaman[OraSaurus]- Original Message -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Tuesday, April 23, 2002 3:33 AM[...] I would also like to point out that not all 'hit ratios'are bad. The FAN hit ratio is a very useful indicator.(see http://miracleas.dk/undskyld/fhr.pdf in the shortterm for further details).Jonathan Lewishttp://www.jlcomp.demon.co.ukAuthor of:Practical Oracle 8i: Building Efficient DatabasesNext Seminar - Australia - July/Augusthttp://www.jlcomp.demon.co.uk/seminar.htmlHost to The Co-Operative Oracle Users' FAQhttp://www.jlcomp.demon.co.uk/faq/ind_faq.html
RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
John & all, I just used the term, OWI. I do not claim to be the originator of this term. But I like it very much. As for the ratios go, I did not use the 'R' word(s) ;) in my short presentation. It was, however, mentioned in the session abstract to get attention. My sincere thanks to all who attended my presentation. Regards, - Kirti -Original Message- Sent: Monday, April 22, 2002 5:24 PM To: Multiple recipients of list ORACLE-L n 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 guessing who won the day! The massive number of defections and the absolute absense of CHR-based-discussions at the Performance round tables was clear evidence that OWI is here to stay! (Mr. R might still rewrite that book sooner than later!) About 20 Listers met for dinner on Sunday night (and again in a larger group at the SeaWorld bash). The meeting was characterized by geek-talk such as 'Can you fit us all in one extent?' i.e. 'can we all sit at one table?'), 'Please coalesce' - 'please move in so that more people can fit into the aisle seats'. Oh Boy, that WAS a lot of fun! 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: Mark Leith [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 22, 2002 4:58 AM > To: Multiple recipients of list ORACLE-L > Subject: Anything new from IOUG? > > > Hi All that recently attended IOUG. > > If you don't already know - I sell "tools" for Oracle. > (delete this now if > you want to DG! ;P) > > I was just wondering if anybody at IOUG had any feedback on > any "new" tools > that were launched, or any tools that made a significant > impact at IOUG? > > This is purely for "vendor awareness" for myself, as I like > to keep up to > date on anything new in and around our particular market > place.. If anybody > saw something and thought "wow!", I'd be interested in > hearing about it. If > you would like to contact me directly about this - please > feel free, though > I feel the list *could* also benefit from this.. > > Cheers > > Mark > > === > Mark Leith | T: +44 (0)1905 330 281 > Sales & Marketing | F: +44 (0)870 127 5283 > Cool Tools UK Ltd | E: [EMAIL PROTECTED] > === >http://www.cool-tools.co.uk >Maximising throughput & performance > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Leith > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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 in
RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
Could you elaborate a little more on StorageXpert and what it has shown you? We are on 8.1.7 using EMC (about 200gb) and are getting ready to eval Quest. How does it show you performance issues in this environment? Thanks. > -Original Message- > From: John Kanagaraj [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 22, 2002 6:24 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Anything new from IOUG? + "OWI" Born!! > (Anjo/Mogens, please > n > > > 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 guessing who > won the day! The > massive number of defections and the absolute absense of > CHR-based-discussions at the Performance round tables was > clear evidence > that OWI is here to stay! (Mr. R might still rewrite that > book sooner than > later!) > > About 20 Listers met for dinner on Sunday night (and again in > a larger group > at the SeaWorld bash). The meeting was characterized by > geek-talk such as > 'Can you fit us all in one extent?' i.e. 'can we all sit at > one table?'), > 'Please coalesce' - 'please move in so that more people can > fit into the > aisle seats'. > > Oh Boy, that WAS a lot of fun! > > 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: Mark Leith [mailto:[EMAIL PROTECTED]] > > Sent: Monday, April 22, 2002 4:58 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Anything new from IOUG? > > > > > > Hi All that recently attended IOUG. > > > > If you don't already know - I sell "tools" for Oracle. > > (delete this now if > > you want to DG! ;P) > > > > I was just wondering if anybody at IOUG had any feedback on > > any "new" tools > > that were launched, or any tools that made a significant > > impact at IOUG? > > > > This is purely for "vendor awareness" for myself, as I like > > to keep up to > > date on anything new in and around our particular market > > place.. If anybody > > saw something and thought "wow!", I'd be interested in > > hearing about it. If > > you would like to contact me directly about this - please > > feel free, though > > I feel the list *could* also benefit from this.. > > > > Cheers > > > > Mark > > > > === > > Mark Leith | T: +44 (0)1905 330 281 > > Sales & Marketing | F: +44 (0)870 127 5283 > > Cool Tools UK Ltd | E: [EMAIL PROTECTED] > > === > >http://www.cool-tools.co.uk > >Maximising throughput & performance > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Mark Leith > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / > Mailing Lists > > -
Re: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
There is one ratio that is a far better indicator than any of that fancy wait analysis stuff - the USR (User Satisfaction Ratio). I usually consider the system to be optimal if the USR is near 97% (the other 3% are chronic whiners anyway). Of course, this does not apply if the CEO is in that 3%. Any CEO waits are considered unacceptable. Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, April 23, 2002 3:33 AM [...] > I would also like to point out that not all 'hit ratios' > are bad. The FAN hit ratio is a very useful indicator. > (see http://miracleas.dk/undskyld/fhr.pdf in the short > term for further details). > > > Jonathan Lewis > http://www.jlcomp.demon.co.uk > > Author of: > Practical Oracle 8i: Building Efficient Databases > > Next Seminar - Australia - July/August > http://www.jlcomp.demon.co.uk/seminar.html > > Host to The Co-Operative Oracle Users' FAQ > http://www.jlcomp.demon.co.uk/faq/ind_faq.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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).
Re: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
I think I can make the same claim - probably because I'm too lazy. But I have been known to say things like: Value X is pretty big compared to value Y Of course, X is often 'the amount of work you say you are doing' whilst Y is 'the amount of work the database is doing'. But most of the time X is 'the amount of time it ought to take' and Y is 'the amount of time it does take'. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 23 April 2002 08:37 please n | |I have never (honestly) |calculated any buffer cache hit ratio. I am probably one of the few people in |the world who can say that. | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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).
Re: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
Did anyone at IOUG-A mention the two biggest jokes about The Buffer Cache Hit Ratio ? First that there are lots of buffer accesses that Oracle doesn't record in the statistics it gives you; and secondly that there are lots of buffer accesses that it does tell you about that have not yet been included in any of the formulae that I've ever seen. The former can be seen quite clearly through a couple of controlled experiments where you match logical I/O against CBC latch gets. The second arises because the 'buffer is pinned' is a count of buffer visits through a 'short-cut'; and the value never gets mentioned. I would also like to point out that not all 'hit ratios' are bad. The FAN hit ratio is a very useful indicator. (see http://miracleas.dk/undskyld/fhr.pdf in the short term for further details). Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 23 April 2002 04:24 please n |> |> 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 :) |> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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).
Re: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
Ratios are not a bad thing (did I really write that down ?!) They are just useless in performance tuning ;-) Well even in the YAPP method I use the ratio's, but in tuning Oracle systems since Oracle version 6 (before Oracle 6, you could only 2.5 tps no mather what you did), I have never (honestly) calculated any buffer cache hit ratio. I am probably one of the few people in the world who can say that. The starting point of a tuning or toubleshooting exercise is not the statistics (ratio or wait or what ever), it is the end user. If the end user complains we start investigating. Now the end user can complain about basically two things: bad response times or bad throughput. Too many DBA's still decide by themselves that that are performance problems without checking with end-users (Gaja calls this CTD) I had a system a couple of weeks ago that did 15000 checkpoints in an hour. The reason was that log_checkpoint_interval was set to 24. However the performance for the end users was fine (believe it or not) and nothing was changed on the system, however one batch at night ran in 2 hours that could be finished in 20 minutes (and the customer didn't care about that). Anjo. John Kanagaraj wrote: > 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
RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
Yes I think many people often forget the simple value in the tracking of
values and watching for discrepancies. I have a simple script that I used
on a HP box that i was SA on that simply collected a bunch of simple stats
from sar and vmstat and mailed them to me. I was able to prove many times
that the changes that had been requested helped or hurt the system.
--
=
Peter McLarty E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane, AustraliaMobile: +61 (0)402 094 238
Facsimile: +61 (0)7 3303 3048
=
A great pleasure in life is doing what people say you cannot do.
- Walter Bagehot (1826-1877 British Economist)
=
Mincom "The People, The Experience, The Vision"
=
Connor McDonald <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
23-04-2002 09:44 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Fax to:
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
> guessing who won the day! The
> massive number of defections and the absolute
> absense of
> CHR-based-discussions at the Performance round
> tables was clear evidence
> that OWI is here to stay! (Mr. R might still rewrite
> that book sooner than
> later!)
>
> About 20 Listers met for dinner on Sunday night (and
> again in a larger group
> at the SeaWorld bash). The meeting was characterized
> by geek-talk such as
> 'Can you fit us all in one extent?' i.e. 'can we all
> sit at one table?'),
> 'Please coalesce' - 'please move in so that more
> people can fit into the
> aisle seats'.
>
> Oh Boy, that WAS a lot of fun!
>
> 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: Mark Leith [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, April 22, 2002 4:58 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Anything new from IOUG?
> >
> >
> > Hi All that recently attended IOUG.
> >
> > If you don't already know - I sell "tools&qu
Re: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please 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 > > > guessing who won the day! The > > > massive number of defections and the absolute > > > absense of > > > CHR-based-discussions at the Performance round > > > tables was clear evidence > > > that OWI is here to
RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
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 > > guessing who won the day! The > > massive number of defections and the absolute > > absense of > > CHR-based-discussions at the Performance round > > tables was clear evidence > > that OWI is here to stay! (Mr. R might still rewrite > > that book sooner than > > later!) > > > > About 20 Listers met for dinner on Sunday night (and > > again in a larger group > > at the SeaWorld bash). The meeting was characterized > > by geek-talk such as > > 'Can you fit us all in one extent?' i.e. 'can we all > > sit at one table?'), > > 'Please coalesce' - 'please move in so that more > > people can fit into the > > aisle seats'. > > > > Oh Boy, that WAS a lot of fun! > > > > John Kanagaraj > > Oracle Applications DBA > > DBSoft Inc > >
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 > guessing who won the day! The > massive number of defections and the absolute > absense of > CHR-based-discussions at the Performance round > tables was clear evidence > that OWI is here to stay! (Mr. R might still rewrite > that book sooner than > later!) > > About 20 Listers met for dinner on Sunday night (and > again in a larger group > at the SeaWorld bash). The meeting was characterized > by geek-talk such as > 'Can you fit us all in one extent?' i.e. 'can we all > sit at one table?'), > 'Please coalesce' - 'please move in so that more > people can fit into the > aisle seats'. > > Oh Boy, that WAS a lot of fun! > > 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: Mark Leith [mailto:[EMAIL PROTECTED]] > > Sent: Monday, April 22, 2002 4:58 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Anything new from IOUG? > > > > > > Hi All that recently attended IOUG. > > > > If you don't already know - I sell "tools" for > Oracle. > > (delete this now if > > you want to DG! ;P) > > > > I was just wondering if anybody at IOUG had any > feedback on > > any "new" tools > > that were launched, or any tools that made a > significant > > impact at IOUG? > > > > This is purely for "vendor awareness" for myself, > as I like > > to keep up to > > date on anything new in and around our particular > market > > place.. If anybody > > saw something and thought "wow!", I'd be > interested in > > hearing about it. If > > you would like to contact me directly about this - > please > > feel free, though > > I feel the list *could* also benefit from this.. > > > > Cheers > > > > Mark > > > > > === > > Mark Leith | T: +44 (0)1905 330 281 > > Sales & Marketing | F: +44 (0)870 127 5283 > > Cool Tools UK Ltd | E: [EMAIL PROTECTED] > > > === > >http://www.cool-tools.co.uk > >Maximising throughput & performance > > > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Mark Leith > > 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). > > > --
RE: Anything new from IOUG? + "OWI" Born!! (Anjo/Mogens, please n
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 guessing who won the day! The massive number of defections and the absolute absense of CHR-based-discussions at the Performance round tables was clear evidence that OWI is here to stay! (Mr. R might still rewrite that book sooner than later!) About 20 Listers met for dinner on Sunday night (and again in a larger group at the SeaWorld bash). The meeting was characterized by geek-talk such as 'Can you fit us all in one extent?' i.e. 'can we all sit at one table?'), 'Please coalesce' - 'please move in so that more people can fit into the aisle seats'. Oh Boy, that WAS a lot of fun! 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: Mark Leith [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 22, 2002 4:58 AM > To: Multiple recipients of list ORACLE-L > Subject: Anything new from IOUG? > > > Hi All that recently attended IOUG. > > If you don't already know - I sell "tools" for Oracle. > (delete this now if > you want to DG! ;P) > > I was just wondering if anybody at IOUG had any feedback on > any "new" tools > that were launched, or any tools that made a significant > impact at IOUG? > > This is purely for "vendor awareness" for myself, as I like > to keep up to > date on anything new in and around our particular market > place.. If anybody > saw something and thought "wow!", I'd be interested in > hearing about it. If > you would like to contact me directly about this - please > feel free, though > I feel the list *could* also benefit from this.. > > Cheers > > Mark > > === > Mark Leith | T: +44 (0)1905 330 281 > Sales & Marketing | F: +44 (0)870 127 5283 > Cool Tools UK Ltd | E: [EMAIL PROTECTED] > === >http://www.cool-tools.co.uk >Maximising throughput & performance > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Leith > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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).
