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 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
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 '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
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, 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
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 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
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
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 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
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 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
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 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
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 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
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 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
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
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 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
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
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
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
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 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
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 information (like subscribing). -- Please see the official ORACLE-L
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 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
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
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 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
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).
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). -- 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
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 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
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 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
