RE: What to look for in STATSPACK report
I still go to www.oraperf.com and it still greets me with the same interface and provides the same services that it did before Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Hemant K Chitale Sent: Wednesday, January 28, 2004 9:59 AM To: Multiple recipients of list ORACLE-L There certainly _was_ a site called http://oraperf.veritas.com Hemant At 05:59 AM 27-01-04 -0800, you wrote: Anjo So what was the deal with oraperf.veritas.com if you don't mind my asking? I subscribed to it sometime before Christmas, but when I went to use it a week or so ago, it had disappeared and I had to (re)subscribe to www.oraperf.com. -- David Lord -Original Message- From: Anjo Kolk [mailto:[EMAIL PROTECTED] Sent: 27 January 2004 13:29 To: Multiple recipients of list ORACLE-L Subject: RE: What to look for in STATSPACK report No, the server is in my basement. Anjo. -Original Message- Rachel Carmichael Sent: Tuesday, January 27, 2004 11:44 AM To: Multiple recipients of list ORACLE-L that's pretty definitive. :) I did say retaining permanent ownership Is Veritas hosting it for you? --- Anjo Kolk [EMAIL PROTECTED] wrote: No, It is mine! Anjo. -Original Message- Rachel Carmichael Sent: Friday, January 23, 2004 11:49 AM To: Multiple recipients of list ORACLE-L well, I can't get to the site at the moment to test it.. if I remember correctly, Anjo said he had leased it to Veritas for a couple of years, while retaining permanent ownership. On the other hand, he's on this list, he can confirm or deny that himself! --- Mogens_Nxrgaard [EMAIL PROTECTED] wrote: Hi Tim, Are you sure it's still owned by Veritas? Doesn't look that way when I checked it just now. Mogens Tim Gorman wrote: Helmut, Register with http://www.oraperf.com; and run those STATSPACK reports through the YAPP analyzer, which will reformat them in such a way that they make sense. All of the ratio stuff on the STATSPACK report is ignored by the YAPP analyzer, and instead the reformatting looks at things from the standpoint of response-time analysis, as described in the white papers at http://www.oraperf.com/whitepapers.html;. Yes, I know OraPerf is now owned by Veritas and the real URLs are different, but it'll always be just good old oraperf.com hopefully, no matter who Anjo works for... :-) Hope this helps... -Tim on 1/18/04 11:24 PM, Daiminger, Helmut at [EMAIL PROTECTED] wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
RE: What to look for in STATSPACK report
There certainly _was_ a site called http://oraperf.veritas.com Hemant At 05:59 AM 27-01-04 -0800, you wrote: Anjo So what was the deal with oraperf.veritas.com if you don't mind my asking? I subscribed to it sometime before Christmas, but when I went to use it a week or so ago, it had disappeared and I had to (re)subscribe to www.oraperf.com. -- David Lord -Original Message- From: Anjo Kolk [mailto:[EMAIL PROTECTED] Sent: 27 January 2004 13:29 To: Multiple recipients of list ORACLE-L Subject: RE: What to look for in STATSPACK report No, the server is in my basement. Anjo. -Original Message- Rachel Carmichael Sent: Tuesday, January 27, 2004 11:44 AM To: Multiple recipients of list ORACLE-L that's pretty definitive. :) I did say retaining permanent ownership Is Veritas hosting it for you? --- Anjo Kolk [EMAIL PROTECTED] wrote: No, It is mine! Anjo. -Original Message- Rachel Carmichael Sent: Friday, January 23, 2004 11:49 AM To: Multiple recipients of list ORACLE-L well, I can't get to the site at the moment to test it.. if I remember correctly, Anjo said he had leased it to Veritas for a couple of years, while retaining permanent ownership. On the other hand, he's on this list, he can confirm or deny that himself! --- Mogens_Nxrgaard [EMAIL PROTECTED] wrote: Hi Tim, Are you sure it's still owned by Veritas? Doesn't look that way when I checked it just now. Mogens Tim Gorman wrote: Helmut, Register with http://www.oraperf.com; and run those STATSPACK reports through the YAPP analyzer, which will reformat them in such a way that they make sense. All of the ratio stuff on the STATSPACK report is ignored by the YAPP analyzer, and instead the reformatting looks at things from the standpoint of response-time analysis, as described in the white papers at http://www.oraperf.com/whitepapers.html;. Yes, I know OraPerf is now owned by Veritas and the real URLs are different, but it'll always be just good old oraperf.com hopefully, no matter who Anjo works for... :-) Hope this helps... -Tim on 1/18/04 11:24 PM, Daiminger, Helmut at [EMAIL PROTECTED] wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo
RE: What to look for in STATSPACK report
No, It is mine! Anjo. -Original Message- Rachel Carmichael Sent: Friday, January 23, 2004 11:49 AM To: Multiple recipients of list ORACLE-L well, I can't get to the site at the moment to test it.. if I remember correctly, Anjo said he had leased it to Veritas for a couple of years, while retaining permanent ownership. On the other hand, he's on this list, he can confirm or deny that himself! --- Mogens_Nxrgaard [EMAIL PROTECTED] wrote: Hi Tim, Are you sure it's still owned by Veritas? Doesn't look that way when I checked it just now. Mogens Tim Gorman wrote: Helmut, Register with http://www.oraperf.com; and run those STATSPACK reports through the YAPP analyzer, which will reformat them in such a way that they make sense. All of the ratio stuff on the STATSPACK report is ignored by the YAPP analyzer, and instead the reformatting looks at things from the standpoint of response-time analysis, as described in the white papers at http://www.oraperf.com/whitepapers.html;. Yes, I know OraPerf is now owned by Veritas and the real URLs are different, but it'll always be just good old oraperf.com hopefully, no matter who Anjo works for... :-) Hope this helps... -Tim on 1/18/04 11:24 PM, Daiminger, Helmut at [EMAIL PROTECTED] wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: What to look for in STATSPACK report
that's pretty definitive. :) I did say retaining permanent ownership Is Veritas hosting it for you? --- Anjo Kolk [EMAIL PROTECTED] wrote: No, It is mine! Anjo. -Original Message- Rachel Carmichael Sent: Friday, January 23, 2004 11:49 AM To: Multiple recipients of list ORACLE-L well, I can't get to the site at the moment to test it.. if I remember correctly, Anjo said he had leased it to Veritas for a couple of years, while retaining permanent ownership. On the other hand, he's on this list, he can confirm or deny that himself! --- Mogens_Nxrgaard [EMAIL PROTECTED] wrote: Hi Tim, Are you sure it's still owned by Veritas? Doesn't look that way when I checked it just now. Mogens Tim Gorman wrote: Helmut, Register with http://www.oraperf.com; and run those STATSPACK reports through the YAPP analyzer, which will reformat them in such a way that they make sense. All of the ratio stuff on the STATSPACK report is ignored by the YAPP analyzer, and instead the reformatting looks at things from the standpoint of response-time analysis, as described in the white papers at http://www.oraperf.com/whitepapers.html;. Yes, I know OraPerf is now owned by Veritas and the real URLs are different, but it'll always be just good old oraperf.com hopefully, no matter who Anjo works for... :-) Hope this helps... -Tim on 1/18/04 11:24 PM, Daiminger, Helmut at [EMAIL PROTECTED] wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: What to look for in STATSPACK report
No, the server is in my basement. Anjo. -Original Message- Rachel Carmichael Sent: Tuesday, January 27, 2004 11:44 AM To: Multiple recipients of list ORACLE-L that's pretty definitive. :) I did say retaining permanent ownership Is Veritas hosting it for you? --- Anjo Kolk [EMAIL PROTECTED] wrote: No, It is mine! Anjo. -Original Message- Rachel Carmichael Sent: Friday, January 23, 2004 11:49 AM To: Multiple recipients of list ORACLE-L well, I can't get to the site at the moment to test it.. if I remember correctly, Anjo said he had leased it to Veritas for a couple of years, while retaining permanent ownership. On the other hand, he's on this list, he can confirm or deny that himself! --- Mogens_Nxrgaard [EMAIL PROTECTED] wrote: Hi Tim, Are you sure it's still owned by Veritas? Doesn't look that way when I checked it just now. Mogens Tim Gorman wrote: Helmut, Register with http://www.oraperf.com; and run those STATSPACK reports through the YAPP analyzer, which will reformat them in such a way that they make sense. All of the ratio stuff on the STATSPACK report is ignored by the YAPP analyzer, and instead the reformatting looks at things from the standpoint of response-time analysis, as described in the white papers at http://www.oraperf.com/whitepapers.html;. Yes, I know OraPerf is now owned by Veritas and the real URLs are different, but it'll always be just good old oraperf.com hopefully, no matter who Anjo works for... :-) Hope this helps... -Tim on 1/18/04 11:24 PM, Daiminger, Helmut at [EMAIL PROTECTED] wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: What to look for in STATSPACK report
- -Original Message- - From: Anjo Kolk [mailto:[EMAIL PROTECTED] - Sent: Tuesday, January 27, 2004 8:29 AM - To: Multiple recipients of list ORACLE-L - Subject: RE: What to look for in STATSPACK report - - - No, the server is in my basement. why? was it being a bad server?;-) -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] The Truth is realized in an instant; the Act is practiced step by step. - Zen saying -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: What to look for in STATSPACK report
0kay, then the alcohol we were consuming fogged my brain :) getting older is a pain in the butt... I do know I was getting emails from Veritas about the oraperf site. That must be where the confusion lies --- Anjo Kolk [EMAIL PROTECTED] wrote: No, the server is in my basement. Anjo. -Original Message- Rachel Carmichael Sent: Tuesday, January 27, 2004 11:44 AM To: Multiple recipients of list ORACLE-L that's pretty definitive. :) I did say retaining permanent ownership Is Veritas hosting it for you? --- Anjo Kolk [EMAIL PROTECTED] wrote: No, It is mine! Anjo. -Original Message- Rachel Carmichael Sent: Friday, January 23, 2004 11:49 AM To: Multiple recipients of list ORACLE-L well, I can't get to the site at the moment to test it.. if I remember correctly, Anjo said he had leased it to Veritas for a couple of years, while retaining permanent ownership. On the other hand, he's on this list, he can confirm or deny that himself! --- Mogens_Nxrgaard [EMAIL PROTECTED] wrote: Hi Tim, Are you sure it's still owned by Veritas? Doesn't look that way when I checked it just now. Mogens Tim Gorman wrote: Helmut, Register with http://www.oraperf.com; and run those STATSPACK reports through the YAPP analyzer, which will reformat them in such a way that they make sense. All of the ratio stuff on the STATSPACK report is ignored by the YAPP analyzer, and instead the reformatting looks at things from the standpoint of response-time analysis, as described in the white papers at http://www.oraperf.com/whitepapers.html;. Yes, I know OraPerf is now owned by Veritas and the real URLs are different, but it'll always be just good old oraperf.com hopefully, no matter who Anjo works for... :-) Hope this helps... -Tim on 1/18/04 11:24 PM, Daiminger, Helmut at [EMAIL PROTECTED] wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538
RE: What to look for in STATSPACK report
Anjo So what was the deal with oraperf.veritas.com if you don't mind my asking? I subscribed to it sometime before Christmas, but when I went to use it a week or so ago, it had disappeared and I had to (re)subscribe to www.oraperf.com. -- David Lord -Original Message- From: Anjo Kolk [mailto:[EMAIL PROTECTED] Sent: 27 January 2004 13:29 To: Multiple recipients of list ORACLE-L Subject: RE: What to look for in STATSPACK report No, the server is in my basement. Anjo. -Original Message- Rachel Carmichael Sent: Tuesday, January 27, 2004 11:44 AM To: Multiple recipients of list ORACLE-L that's pretty definitive. :) I did say retaining permanent ownership Is Veritas hosting it for you? --- Anjo Kolk [EMAIL PROTECTED] wrote: No, It is mine! Anjo. -Original Message- Rachel Carmichael Sent: Friday, January 23, 2004 11:49 AM To: Multiple recipients of list ORACLE-L well, I can't get to the site at the moment to test it.. if I remember correctly, Anjo said he had leased it to Veritas for a couple of years, while retaining permanent ownership. On the other hand, he's on this list, he can confirm or deny that himself! --- Mogens_Nxrgaard [EMAIL PROTECTED] wrote: Hi Tim, Are you sure it's still owned by Veritas? Doesn't look that way when I checked it just now. Mogens Tim Gorman wrote: Helmut, Register with http://www.oraperf.com; and run those STATSPACK reports through the YAPP analyzer, which will reformat them in such a way that they make sense. All of the ratio stuff on the STATSPACK report is ignored by the YAPP analyzer, and instead the reformatting looks at things from the standpoint of response-time analysis, as described in the white papers at http://www.oraperf.com/whitepapers.html;. Yes, I know OraPerf is now owned by Veritas and the real URLs are different, but it'll always be just good old oraperf.com hopefully, no matter who Anjo works for... :-) Hope this helps... -Tim on 1/18/04 11:24 PM, Daiminger, Helmut at [EMAIL PROTECTED] wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try
Statspack Will Not Install Oracle 9.2.0.4
The order by st1.hash_value,ss.text_subset; -- deadlock avoidance Statement in the following Statspack code causes the package not to compile. Oracle 9.2.0.4.0 64 bit. Compatible is set to 9.2.0 If I remove the two ORDER BY's in error the package compiles fine. Could not find anything on Google or Metalink about this. insert into stats$sqltext ( hash_value , text_subset , piece , sql_text , address , command_type , last_snap_id ) select st1.hash_value , ss.text_subset , st1.piece , st1.sql_text , st1.address , st1.command_type , ss.snap_id from v$sqltext st1 , stats$sql_summary ss where ss.snap_id = l_snap_id and ss.dbid= p_dbid and ss.instance_number = p_instance_number and st1.hash_value = ss.hash_value and st1.address= ss.address and not exists (select 1 from stats$sqltext st2 where st2.hash_value = ss.hash_value and st2.text_subset = ss.text_subset ) order by st1.hash_value,ss.text_subset; -- deadlock avoidance -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: What to look for in STATSPACK report
If you're new to perl, setting this up might be somewhat difficult. It requires installing DBD::Chart, which in turn requires some graphics libraries to be installed, among them ImageMagic if I recall correctly. Installing ImageMagic can be rather difficult depending on platform. On Linux it is possible to just install the binaries, other platforms may present problems. YYMV Jared Joan Hsieh [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2004 08:19 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: What to look for in STATSPACK report Jared, Thanks! I'd like to try perl, but I have to admit I am totally naive on this subject. I am thinking to take a course. (free for me) How much efforts in order to set this up? ps, your graph is very impressive. I still have trouble to make the graph from excel. Thanks to Dennis, after I changed text to cloumns, it made a little progress. But I am still struggling to make it work. Joan [EMAIL PROTECTED] wrote: If you're willing to go to the trouble of setting up Perl, DBI, DBD::Oracle, DBD::Chart and its dependent libs ( graphics ), I'll send the Perl/Shell stuff I use to generate charts. It includes some modifications to YAPPPACK. That sound OK Mogens? Jared Joan Hsieh [EMAIL PROTECTED] To:Multiple Sent by: [EMAIL PROTECTED] recipients of list ORACLE-L [EMAIL PROTECTED] 01/22/2004 09:19 AM cc: Please respond to ORACLE-L Subject:Re: What to look for in STATSPACK report Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: Statspack Will Not Install Oracle 9.2.0.4
Ethan: You can remove the order by if you are not using RAC. Basically it is to avoid two identical SQLs inserted at the SAME time in RAC setup. If you are using RAC just add another column in the order by condition. (st1.hash_value,ss.text_subset,st1.piece) I don't have the bug # handy. But I was told this is fixed in 10g ;) KG = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Statspack Will Not Install Oracle 9.2.0.4
H on our 9204 instance this package is compiled with the order by ... our compatible is set to 9.2.0.4 Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Post, Ethan Sent: Monday, January 26, 2004 12:54 PM To: Multiple recipients of list ORACLE-L The order by st1.hash_value,ss.text_subset; -- deadlock avoidance Statement in the following Statspack code causes the package not to compile. Oracle 9.2.0.4.0 64 bit. Compatible is set to 9.2.0 If I remove the two ORDER BY's in error the package compiles fine. Could not find anything on Google or Metalink about this. insert into stats$sqltext ( hash_value , text_subset , piece , sql_text , address , command_type , last_snap_id ) select st1.hash_value , ss.text_subset , st1.piece , st1.sql_text , st1.address , st1.command_type , ss.snap_id from v$sqltext st1 , stats$sql_summary ss where ss.snap_id = l_snap_id and ss.dbid= p_dbid and ss.instance_number = p_instance_number and st1.hash_value = ss.hash_value and st1.address= ss.address and not exists (select 1 from stats$sqltext st2 where st2.hash_value = ss.hash_value and st2.text_subset = ss.text_subset ) order by st1.hash_value,ss.text_subset; -- deadlock avoidance -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). ** 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 corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Statspack Will Not Install Oracle 9.2.0.4
Thanks. Gee, the Oracle sales folks keep telling our Lead Architect that RAC requires zero code changes...guess this was not true for Statspack. :) -Original Message- Sent: Monday, January 26, 2004 12:14 PM To: Multiple recipients of list ORACLE-L Ethan: You can remove the order by if you are not using RAC. Basically it is to avoid two identical SQLs inserted at the SAME time in RAC setup. If you are using RAC just add another column in the order by condition. (st1.hash_value,ss.text_subset,st1.piece) I don't have the bug # handy. But I was told this is fixed in 10g ;) KG = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: What to look for in STATSPACK report
Hi Tim, Are you sure it's still owned by Veritas? Doesn't look that way when I checked it just now. Mogens Tim Gorman wrote: Helmut, Register with http://www.oraperf.com; and run those STATSPACK reports through the YAPP analyzer, which will reformat them in such a way that they make sense. All of the ratio stuff on the STATSPACK report is ignored by the YAPP analyzer, and instead the reformatting looks at things from the standpoint of response-time analysis, as described in the white papers at http://www.oraperf.com/whitepapers.html;. Yes, I know OraPerf is now owned by Veritas and the real URLs are different, but it'll always be just good old oraperf.com hopefully, no matter who Anjo works for... :-) Hope this helps... -Tim on 1/18/04 11:24 PM, Daiminger, Helmut at [EMAIL PROTECTED] wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: What to look for in STATSPACK report
well, I can't get to the site at the moment to test it.. if I remember correctly, Anjo said he had leased it to Veritas for a couple of years, while retaining permanent ownership. On the other hand, he's on this list, he can confirm or deny that himself! --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: Hi Tim, Are you sure it's still owned by Veritas? Doesn't look that way when I checked it just now. Mogens Tim Gorman wrote: Helmut, Register with http://www.oraperf.com; and run those STATSPACK reports through the YAPP analyzer, which will reformat them in such a way that they make sense. All of the ratio stuff on the STATSPACK report is ignored by the YAPP analyzer, and instead the reformatting looks at things from the standpoint of response-time analysis, as described in the white papers at http://www.oraperf.com/whitepapers.html;. Yes, I know OraPerf is now owned by Veritas and the real URLs are different, but it'll always be just good old oraperf.com hopefully, no matter who Anjo works for... :-) Hope this helps... -Tim on 1/18/04 11:24 PM, Daiminger, Helmut at [EMAIL PROTECTED] wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: What to look for in STATSPACK report
I've tried to get ahold of Anjo off-list several times. I'm sure he is busy, but I really need to get ahold of him. Can someone off-list ask him to e-mail me at either/both of these addresses? [EMAIL PROTECTED] [EMAIL PROTECTED] Thanks Stephen [EMAIL PROTECTED] 01/23/04 12:19AM Hi Tim, Are you sure it's still owned by Veritas? Doesn't look that way when I checked it just now. Mogens Tim Gorman wrote: Helmut, Register with http://www.oraperf.com; and run those STATSPACK reports through the YAPP analyzer, which will reformat them in such a way that they make sense. All of the ratio stuff on the STATSPACK report is ignored by the YAPP analyzer, and instead the reformatting looks at things from the standpoint of response-time analysis, as described in the white papers at http://www.oraperf.com/whitepapers.html;. Yes, I know OraPerf is now owned by Veritas and the real URLs are different, but it'll always be just good old oraperf.com hopefully, no matter who Anjo works for... :-) Hope this helps... -Tim on 1/18/04 11:24 PM, Daiminger, Helmut at [EMAIL PROTECTED] wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: What to look for in STATSPACK report
Jared, Thanks! I'd like to try perl, but I have to admit I am totally naive on this subject. I am thinking to take a course. (free for me) How much efforts in order to set this up? ps, your graph is very impressive. I still have trouble to make the graph from excel. Thanks to Dennis, after I changed text to cloumns, it made a little progress. But I am still struggling to make it work. Joan [EMAIL PROTECTED] wrote: If you're willing to go to the trouble of setting up Perl, DBI, DBD::Oracle, DBD::Chart and its dependent libs ( graphics ), I'll send the Perl/Shell stuff I use to generate charts. It includes some modifications to YAPPPACK. That sound OK Mogens? Jared Joan Hsieh [EMAIL PROTECTED] To:Multiple Sent by: [EMAIL PROTECTED] recipients of list ORACLE-L [EMAIL PROTECTED] 01/22/2004 09:19 AM cc: Please respond to ORACLE-LSubject:Re: What to look for in STATSPACK report Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http
Re: What to look for in STATSPACK report
Hi Jared, Is this offer open to everybody -:) I would like to get the perl/shell stuff you are referring to. I had problem to install DBI from ActivePerl before (on Windows 2000). I shall try again. Thanks, Quamrul From: Joan Hsieh <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: What to look for in STATSPACK report Date: Fri, 23 Jan 2004 08:19:25 -0800 Jared, Thanks! I'd like to try perl, but I have to admit I am totally naive on this subject. I am thinking to take a course. (free for me) How much efforts in order to set this up? ps, your graph is very impressive. I still have trouble to make the graph from excel. Thanks to Dennis, after I changed text to cloumns, it made a little progress. But I am still struggling to make it work. Joan [EMAIL PROTECTED] wrote: If you're willing to go to the trouble of setting up Perl, DBI, DBD::Oracle, DBD::Chart and its dependent libs ( graphics ), I'll send the Perl/Shell stuff I use to generate charts. It includes some modifications to YAPPPACK. That sound OK Mogens? Jared Joan Hsieh <[EMAIL PROTECTED]> To:Multiple Sent by: [EMAIL PROTECTED] recipients of list ORACLE-L <[EMAIL PROTECTED]> 01/22/2004 09:19 AM cc: Please respond to ORACLE-LSubject:Re: What to look for in STATSPACK report Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: You will find a utility add on for statspack at Mogens company site, www.miracleas.dk.It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless.I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times.When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECT
Re: What to look for in STATSPACK report
I run it on Linux. Should work ok on Win2k, though I haven't tried it. The modified YAPPPACK and Perl scripts are at http://www.cybcon.com/~jkstill/util/zips/yapp_chart.tgz Works in 8i and 9i. Jared Quamrul Polash [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/23/2004 09:04 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: What to look for in STATSPACK report Hi Jared, Is this offer open to everybody -:) I would like to get the perl/shell stuff you are referring to. I had problem to install DBI from ActivePerl before (on Windows 2000). I shall try again. Thanks, Quamrul From: Joan Hsieh Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Subject: Re: What to look for in STATSPACK report Date: Fri, 23 Jan 2004 08:19:25 -0800 Jared, Thanks! I'd like to try perl, but I have to admit I am totally naive on this subject. I am thinking to take a course. (free for me) How much efforts in order to set this up? ps, your graph is very impressive. I still have trouble to make the graph from excel. Thanks to Dennis, after I changed text to cloumns, it made a little progress. But I am still struggling to make it work. Joan [EMAIL PROTECTED] wrote: If you're willing to go to the trouble of setting up Perl, DBI, DBD::Oracle, DBD::Chart and its dependent libs ( graphics ), I'll send the Perl/Shell stuff I use to generate charts. It includes some modifications to YAPPPACK. That sound OK Mogens? Jared Joan Hsieh To:Multiple Sent by: [EMAIL PROTECTED] recipients of list ORACLE-L 01/22/2004 09:19 AM cc: Please respond to ORACLE-L Subject:Re: What to look for in STATSPACK report Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: What to look for in STATSPACK report
Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: What to look for in STATSPACK report
I had this same problem. It ended up being that when I opened the file in exel, all the columns from the csv went into one excel column and for some reason it wasn't apparentor something like that. .now if I could only remember what it was I did to fix it. hmmm. ..i think it was some searching and replacing or something. ..that should get you started though. ...sorry for the not so helpful post, but maybe this will trigger something. chris -Original Message- Sent: Thursday, January 22, 2004 11:19 AM To: Multiple recipients of list ORACLE-L Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network
RE: What to look for in STATSPACK report
Chris - In Excel, click on Data -- Text to Columns. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 1:00 PM To: Multiple recipients of list ORACLE-L I had this same problem. It ended up being that when I opened the file in exel, all the columns from the csv went into one excel column and for some reason it wasn't apparentor something like that. .now if I could only remember what it was I did to fix it. hmmm. .i think it was some searching and replacing or something. .that should get you started though. ..sorry for the not so helpful post, but maybe this will trigger something. chris -Original Message- Sent: Thursday, January 22, 2004 11:19 AM To: Multiple recipients of list ORACLE-L Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
Re: What to look for in STATSPACK report
Here's a sample chart. These are generated every morning and available via our intranet. http://www.cybcon.com/~jkstill/yapppack_chart.png Hmmm... Looks like someone is doing a lot of commits at 02:30 and 05:15. Jared Joan Hsieh [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/22/2004 09:19 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: What to look for in STATSPACK report Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: What to look for in STATSPACK report
If you're willing to go to the trouble of setting up Perl, DBI, DBD::Oracle, DBD::Chart and its dependent libs ( graphics ), I'll send the Perl/Shell stuff I use to generate charts. It includes some modifications to YAPPPACK. That sound OK Mogens? Jared Joan Hsieh [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/22/2004 09:19 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: What to look for in STATSPACK report Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nørgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
[oracle-l] Re: What to look for in STATSPACK report
Chris - In Excel, click on Data -- Text to Columns. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 1:00 PM To: Multiple recipients of list ORACLE-L I had this same problem. It ended up being that when I opened the file = in exel, all the columns from the csv went into one excel column and for = some reason it wasn't apparentor something like that. .now if I = could only remember what it was I did to fix it. hmmm. .i think it was some searching and replacing or something. .that should get you started though. ..sorry for the not so helpful post, but maybe this will trigger something. chris -Original Message- Sent: Thursday, January 22, 2004 11:19 AM To: Multiple recipients of list ORACLE-L Jared, I played YAPPPACK quite often some time ago. I like it very much. But somehow I failed to generate the gif file from the csv file as sample shown. Can someone shade me some light on this? I tied very hard to = make the graphs from the csv file but just don't know how. Thanks, Joan Jared Still wrote: =20 You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. =20 You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to = generate response time graphs for your databases. =20 There are many different numbers to look at in a statspack report, = but for day to day monitoring, I find them fairly useless. I mean = really, who's gonna read all that stuff? =20 Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? =20 Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. =20 JMO, =20 Jared =20 On Sun, 2004-01-18 at 23:54, Mogens N=C3=B8rgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at = one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on = it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something = about it in his new book, so go look on asktom.oracle.com for his = opinions about it. If you hope to find threshold numbers for certain values, etc = then someone would have automated it a lng time ago. There can be = two reasons for this not having happened: It depends on the = installation, situation, etc. - or a lot of system-level measurements are in = reality useless. That's pretty much my opinion, but thankfully a lot of = much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are = using the STATSPACK utility. What are sections in statspack reports to look for? What are = threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =3D?ISO-8859-1?Q?Mogens_N=3DF8rgaard?=3D INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting = services = - 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). =20 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] =20 Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.net --=20 Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
Re: What to look for in STATSPACK report
Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: What to look for in STATSPACK report
Helmet, Mogens makes a lot of good points as normal. As usual it's never as simple as we'd like it too be and it depends on how your system runs. One thing that is worth monitoring is changes in statistic values over time. For example if your buffer cache hit ratio is normally 85% during your peak on- line usage but then on it changes to 75% this indicates that something significant has changed and probably needs investigating. It doesn't necessarily mean you have a performance problem because if the users are happy that performance is good and batch is performing as expected then all's OK. (BTW I'm aware that buffer cache hit ratio statistics in isolation aren't a good indicator of performance good or bad.) HTH Cheers, Chris Quoting Mogens Nørgaard [EMAIL PROTECTED]: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: What to look for in STATSPACK report
Helmut, Performance, like beauty, is in the eye of the beholder. Ideal thresholds only exist in poor tuning courses and poor tuning books. IMHO, the wisest thing to do would be to collect information at a time when performance is perfectly satisfactory and use it as a baseline. Then check when there is some _significant_ difference with your baseline. If nobody complains, it means that you can probably allow pretty wide variations for some values. However, if users do really notice (and it's not purely psycho-somatic, as it sometimes is) some degradation, it will be time to enquire. But bear in mind that the most significant indicators will not necessarily be the same ones for all applications, nor even for all times of day. Also, be careful to collect some information about the actual, business-related work being done. I have seen people complaining that they didn't have the same performance as 6 months earlier and forgetting that they were processing twice as many invoices or whatever. Granted, a well-written application should scale. But at least it helps you explain even the most Oracle-challenged manager that it isn't a simple tuning matter (it will be harder to explain that it isn't a question of throwing more hardware to the problem either, but this is another story). HTH Stephane Faroult - --- Original Message --- - From: Daiminger, Helmut [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sun, 18 Jan 2004 22:24:36 Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: What to look for in STATSPACK report
You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nrgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: What to look for in STATSPACK report
Helmut, Register with http://www.oraperf.com; and run those STATSPACK reports through the YAPP analyzer, which will reformat them in such a way that they make sense. All of the ratio stuff on the STATSPACK report is ignored by the YAPP analyzer, and instead the reformatting looks at things from the standpoint of response-time analysis, as described in the white papers at http://www.oraperf.com/whitepapers.html;. Yes, I know OraPerf is now owned by Veritas and the real URLs are different, but it'll always be just good old oraperf.com hopefully, no matter who Anjo works for... :-) Hope this helps... -Tim on 1/18/04 11:24 PM, Daiminger, Helmut at [EMAIL PROTECTED] wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
What to look for in STATSPACK report
Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Statspack wierd Output
Hi Statspack exceptionally showing the following on a particular day :- Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- db file sequential read 100,106,503 41.66 db file scattered read 15,134,519 25.00 latch free 1,692,425 16.67 buffer busy waits 2,067,006 16.66 log file sync 543,5762,449,354 .00 - NOTE - Statspack taken from a Production Database for a 1 hour period on Oracle 8.1.7.4 version Application = Hybrid in nature , Banking s/w 4000 Concurrent Users connect to the Database Qs What can be the cause of the same? Qs Can anything be done about such field value Overflow i.e. ? Will provide any info required Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Statspack wierd Output
modify the sql file and change the format string ... ### indicates value overflow. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, January 06, 2004 9:14 AM To: Multiple recipients of list ORACLE-L Hi Statspack exceptionally showing the following on a particular day :- Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- db file sequential read 100,106,503 41.66 db file scattered read 15,134,519 25.00 latch free 1,692,425 16.67 buffer busy waits 2,067,006 16.66 log file sync 543,5762,449,354 .00 - NOTE - Statspack taken from a Production Database for a 1 hour period on Oracle 8.1.7.4 version Application = Hybrid in nature , Banking s/w 4000 Concurrent Users connect to the Database Qs What can be the cause of the same? Qs Can anything be done about such field value Overflow i.e. ? Will provide any info required Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). ** 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 corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Statspack wierd Output
Just go in the spreport.sql ($ORACLE_HOME/rdbms/admin) and change the time format for that output. On my W2K install it's at line 579 and then again line 635 for the full wait events list. At 07:14 AM 1/6/2004, you wrote: Hi Statspack exceptionally showing the following on a particular day :- Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- db file sequential read 100,106,503 41.66 db file scattered read 15,134,519 25.00 latch free 1,692,425 16.67 buffer busy waits 2,067,006 16.66 log file sync 543,5762,449,354 .00 - NOTE - Statspack taken from a Production Database for a 1 hour period on Oracle 8.1.7.4 version Application = Hybrid in nature , Banking s/w 4000 Concurrent Users connect to the Database Qs What can be the cause of the same? Qs Can anything be done about such field value Overflow i.e. ? Will provide any info required Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Statspack wierd Output
Alternate solution: Don't run it for an hour. One would expect the accumulated wait times to be smaller then and not leading to the value overflow. At 07:14 AM 1/6/2004, you wrote: Statspack taken from a Production Database for a 1 hour period on Oracle 8.1.7.4 version Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Statspack wierd Output
Hi Vivek, I am not a statspack expert but your problem is simply an SQL issue. The ### means that the field format is not big enough for the value being returned in the SQL. Simply open the SQL file and find the SQL that prints this and look for the column format somewhere above that. Change the format so it is wider. The other options is to run the report so that it generates smaller values - shorter time period? hth kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: STATSPACK interpretation
Your Parse time is high, and cpu is close to elapsed, so you are almost certainly hard-parsing all the time. This is either a bug, or you have enough parse activity going on, and a small enough shared pool that you keep invalidating the cursor (and it's dependents). Did you report the Invalidations column in your original post. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November 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] Sent: Tuesday, December 23, 2003 11:19 PM FWIW. The database crashed again.I managed to get in a 10466: BEGIN GENERATE_PRODUCT_KEYS (:1,:2,:3,:4) ; END; call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 2737 1213.001184.60 0 0 0 0 Execute 2737 28.57 28.08 0 0 0 2737 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 5474 1241.571212.68 0 0 0 2737 Looks like maybe that it's an anonymous PL/SQL call just as Jonathan described? Thanks for the replies. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: STATSPACK interpretation
Thanks for the information - that test has been on my TODO list for the last couple of years. Apart from being useful information, it also tells us that it's not the OP's problem, as the number of different possibilities is too low. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November 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] Sent: Tuesday, December 23, 2003 11:44 PM Thanks, Jonathan. Of course you are right :-) Playing with this a little longer, I can get up to 4 versions (child_number from 0 to 3) of the same pl/sql cursor by changing bind variable sizes. It ceases being sharable when bv size changes from 32 to 33, from 128 to 129 and from 2000 to 2001: 1-32 33-128 129-2000 2001-4000 I wonder if this behavior can be changed by some init settings? Thanks, Boris Dali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: STATSPACK interpretation
Jared, Digging into it more, I found out that it's called from an Informatica client. Apparently, the gist of the client-side algorithim is as follows: For each row in (some view) Call generate_product_keys MERGE (upsert) into product table end loop CREATE OR REPLACE PROCEDURE generate_product_keys (v_marketing_model_id IN VARCHAR2, v_model_country_cd IN VARCHAR2, v_product_seq_id IN OUT NUMBER, v_product_id IN OUT NUMBER) IS BEGIN IF v_product_seq_id IS NOT NULL THEN NULL; ELSE SELECT seq_product_seq_id.nextval INTO v_product_seq_id FROM dual; BEGIN SELECT product_id INTO v_product_id FROM product WHERE marketing_model_id = v_marketing_model_id AND model_country_cd = v_model_country_cd; EXCEPTION WHEN NO_DATA_FOUND THEN SELECT seq_product_id.nextval INTO v_product_id FROM dual; END; END IF; END generate_product_keys; / Thanks. -Original Message- Jared Still Sent: Monday, December 22, 2003 6:15 PM To: Multiple recipients of list ORACLE-L What is taking place inside GENERATE_PRODUCT_KEYS() ? Could be dynamic SQL of the worst kind in there. That is, not using bind variables. A 10046 trace level 4 or 12 will show you what is going on there. Jared On Mon, 2003-12-22 at 12:39, Thomas Jeff wrote: We recently experienced a crash on our prod datewarehouse running 9.2.0.2 on AIX 4.3.3.The cause of the crash was 4031 errors generated by background processes (Oracle support has confirmed there is a bug involved), however, since that crash occurred, a certain nightly batch job has slowed to a crawl. Trying to recreate what has happened, I came across this in the STATSPACK report. The interval for this report is 30 minutes. Is it telling me that I have 746 versions of this call eating up 400+ mb at the time of the snapshot? Why would that be? The procedure in question uses bind variables. SQL ordered by Sharable Memory for DB: DSSP Instance: DSSP Snaps: 3309 -3310 - End Sharable Memory Threshold: 1048576 Sharable Mem (b) Executions % Total Hash Value --- 483,580,268 57 411.8539672786 Module: [EMAIL PROTECTED] (TNS V1-V3) BEGINGENERATE_PRODUCT_KEYS (:1,:2,:3,:4) ; END; - SQL ordered by Version Count for DB: DSSP Instance: DSSP Snaps: 3309 -3310 - End Version Count Threshold:20 Version Count Executions Hash Value 746 57539672786 Module: [EMAIL PROTECTED] (TNS V1-V3) BEGINGENERATE_PRODUCT_KEYS (:1,:2,:3,:4) ; END; Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Thomas Jeff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: STATSPACK interpretation
Thomas, The version count is the number of child cursors present in the cache for this SQL. The cursor is not being shared for some reason with 456 versions. The 400m of memory seems a bit excessive. There is a script at Jonathan's site with some info about v$sqlarea and a script you can run that looks at the current memory requirements for a SQL statement. http://www.jlcomp.demon.co.uk/sqlarea.html Does the output match what you see in statspack? Also, the number of executions is much lower than the version count, which is rather odd. There's a bug in early 9i versions that would cause this, but was supposed to be corrected by 9.2.0.2. In experimenting with this, I managed to get 4 different sessions to create 2 versions of a cursor. I'm not sure why as it was pl/sql and variables were used for the calling parameters. A 'select * from v$sql_shared_cursor' did not reveal any reason for it. After bouncing the database and trying this again, I couldn't duplicate it. Maybe a couple of things to pursue here, but perhaps not an abundance of help. :( Jared On Tue, 2003-12-23 at 04:44, Thomas Jeff wrote: Jared, Digging into it more, I found out that it's called from an Informatica client. Apparently, the gist of the client-side algorithim is as follows: For each row in (some view) Call generate_product_keys MERGE (upsert) into product table end loop CREATE OR REPLACE PROCEDURE generate_product_keys (v_marketing_model_id IN VARCHAR2, v_model_country_cd IN VARCHAR2, v_product_seq_id IN OUT NUMBER, v_product_id IN OUT NUMBER) IS BEGIN IF v_product_seq_id IS NOT NULL THEN NULL; ELSE SELECT seq_product_seq_id.nextval INTO v_product_seq_id FROM dual; BEGIN SELECT product_id INTO v_product_id FROM product WHERE marketing_model_id = v_marketing_model_id AND model_country_cd = v_model_country_cd; EXCEPTION WHEN NO_DATA_FOUND THEN SELECT seq_product_id.nextval INTO v_product_id FROM dual; END; END IF; END generate_product_keys; / Thanks. -Original Message- Jared Still Sent: Monday, December 22, 2003 6:15 PM To: Multiple recipients of list ORACLE-L What is taking place inside GENERATE_PRODUCT_KEYS() ? Could be dynamic SQL of the worst kind in there. That is, not using bind variables. A 10046 trace level 4 or 12 will show you what is going on there. Jared On Mon, 2003-12-22 at 12:39, Thomas Jeff wrote: We recently experienced a crash on our prod datewarehouse running 9.2.0.2 on AIX 4.3.3.The cause of the crash was 4031 errors generated by background processes (Oracle support has confirmed there is a bug involved), however, since that crash occurred, a certain nightly batch job has slowed to a crawl. Trying to recreate what has happened, I came across this in the STATSPACK report. The interval for this report is 30 minutes. Is it telling me that I have 746 versions of this call eating up 400+ mb at the time of the snapshot? Why would that be? The procedure in question uses bind variables. SQL ordered by Sharable Memory for DB: DSSP Instance: DSSP Snaps: 3309 -3310 - End Sharable Memory Threshold: 1048576 Sharable Mem (b) Executions % Total Hash Value --- 483,580,268 57 411.8539672786 Module: [EMAIL PROTECTED] (TNS V1-V3) BEGINGENERATE_PRODUCT_KEYS (:1,:2,:3,:4) ; END; - SQL ordered by Version Count for DB: DSSP Instance: DSSP Snaps: 3309 -3310 - End Version Count Threshold:20 Version Count Executions Hash Value 746 57539672786 Module: [EMAIL PROTECTED] (TNS V1-V3) BEGINGENERATE_PRODUCT_KEYS (:1,:2,:3,:4) ; END; Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: STATSPACK interpretation
I recall James Morle saying something about code not being sharable if the declared sizes of the bind variables don't match. If Informatica is using a 3GL to call anonymous pl/sql blocks with different bind variables every time, perhaps it is causing a bind variable mismatch. As for the 400MB - I've often noticed oddities where a new entry is created, but carries forward a report of the memory requirements of earlier variants, so if you have 10 cursors, they don't report 10 units of memory, but 1 + 2 + 3 + 4 + 5 + 6 + 7 + 8 + 9 + 10 units. It is possible that you are seeing some effect like this. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November 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] Sent: Tuesday, December 23, 2003 5:09 PM Thomas, The version count is the number of child cursors present in the cache for this SQL. The cursor is not being shared for some reason with 456 versions. The 400m of memory seems a bit excessive. There is a script at Jonathan's site with some info about v$sqlarea and a script you can run that looks at the current memory requirements for a SQL statement. http://www.jlcomp.demon.co.uk/sqlarea.html Does the output match what you see in statspack? Also, the number of executions is much lower than the version count, which is rather odd. There's a bug in early 9i versions that would cause this, but was supposed to be corrected by 9.2.0.2. In experimenting with this, I managed to get 4 different sessions to create 2 versions of a cursor. I'm not sure why as it was pl/sql and variables were used for the calling parameters. A 'select * from v$sql_shared_cursor' did not reveal any reason for it. After bouncing the database and trying this again, I couldn't duplicate it. Maybe a couple of things to pursue here, but perhaps not an abundance of help. :( Jared On Tue, 2003-12-23 at 04:44, Thomas Jeff wrote: Jared, Digging into it more, I found out that it's called from an Informatica client. Apparently, the gist of the client-side algorithim is as follows: For each row in (some view) Call generate_product_keys MERGE (upsert) into product table end loop -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: STATSPACK interpretation
Thanks Jonathan. I was wondering about those memory columns possibly acting in that manner. I've never used them to track memory though, and wasn't sure how they might act. Google and MetaLink didn't turn up anything too useful in the regard. Now that you mention it, I recall reading recently somewhere that different size bind variables could cause multiple versions. Probably James, but I can't recall where I saw it. Google, Metalinkm mailing lists and a plethora of books and white papers have made it quite difficult, at least for me, to always remember the source of tidbits such as this. Back to the memory, I was somehow able to cause 2 version of the same SQL, as mentioned earlier, but the reason for it did not appear in v$sql_shared_cursor. Jared On Tue, 2003-12-23 at 10:54, Jonathan Lewis wrote: I recall James Morle saying something about code not being sharable if the declared sizes of the bind variables don't match. If Informatica is using a 3GL to call anonymous pl/sql blocks with different bind variables every time, perhaps it is causing a bind variable mismatch. As for the 400MB - I've often noticed oddities where a new entry is created, but carries forward a report of the memory requirements of earlier variants, so if you have 10 cursors, they don't report 10 units of memory, but 1 + 2 + 3 + 4 + 5 + 6 + 7 + 8 + 9 + 10 units. It is possible that you are seeing some effect like this. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November 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] Sent: Tuesday, December 23, 2003 5:09 PM Thomas, The version count is the number of child cursors present in the cache for this SQL. The cursor is not being shared for some reason with 456 versions. The 400m of memory seems a bit excessive. There is a script at Jonathan's site with some info about v$sqlarea and a script you can run that looks at the current memory requirements for a SQL statement. http://www.jlcomp.demon.co.uk/sqlarea.html Does the output match what you see in statspack? Also, the number of executions is much lower than the version count, which is rather odd. There's a bug in early 9i versions that would cause this, but was supposed to be corrected by 9.2.0.2. In experimenting with this, I managed to get 4 different sessions to create 2 versions of a cursor. I'm not sure why as it was pl/sql and variables were used for the calling parameters. A 'select * from v$sql_shared_cursor' did not reveal any reason for it. After bouncing the database and trying this again, I couldn't duplicate it. Maybe a couple of things to pursue here, but perhaps not an abundance of help. :( Jared On Tue, 2003-12-23 at 04:44, Thomas Jeff wrote: Jared, Digging into it more, I found out that it's called from an Informatica client. Apparently, the gist of the client-side algorithim is as follows: For each row in (some view) Call generate_product_keys MERGE (upsert) into product table end loop -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: STATSPACK interpretation
Title: STATSPACK interpretation Using dbms_application_info package also causes that there are several versions of same statement - but theyshare same execution plan. You cancheck if this is the case by queryingv$sqlarea (module and action columns). Regards, Joze -Original Message-From: Thomas Jeff [mailto:[EMAIL PROTECTED]Sent: Monday, December 22, 2003 9:39 PMTo: Multiple recipients of list ORACLE-LSubject: STATSPACK interpretation We recently experienced a crash on our prod datewarehouse running 9.2.0.2 on AIX 4.3.3. The cause of the crash was 4031 errors generated by background processes (Oracle support has confirmed there is a bug involved), however, since that crash occurred, a certain nightly batch job has slowed to a crawl. Trying to recreate what has happened, I came across this in the STATSPACK report. The interval for this report is 30 minutes. Is it telling me that I have 746 versions of this call eating up 400+ mb at the time of the snapshot? Why would that be? The procedure in question uses bind variables. SQL ordered by Sharable Memory for DB: DSSP Instance: DSSP Snaps: 3309 -3310 - End Sharable Memory Threshold: 1048576 Sharable Mem (b) Executions % Total Hash Value --- 483,580,268 57 411.8 539672786 Module: [EMAIL PROTECTED] (TNS V1-V3) BEGIN GENERATE_PRODUCT_KEYS (:1,:2,:3,:4) ; END; - SQL ordered by Version Count for DB: DSSP Instance: DSSP Snaps: 3309 -3310 - End Version Count Threshold: 20 Version Count Executions Hash Value 746 57 539672786 Module: [EMAIL PROTECTED] (TNS V1-V3) BEGIN GENERATE_PRODUCT_KEYS (:1,:2,:3,:4) ; END; Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba
Re: STATSPACK interpretation
Jonathan, Wouldn't bind variable issue that prevents cursor from sharing be visible in bind_mismatch? How can one simulate this? var v varchar2(1) begin select count(5) into :v from dual; end; / select address, sql_text from v$sql where sql_text like '%count(5)%'; ADDRESS SQL_TEXT --- 6DE92A74 SELECT count(5) from dual 6DE960D0 begin select count(5) into :v from dual; end; -- Change a bind variable size: var v varchar2(30) begin select count(5) into :v from dual; end; / -- same output, no change, both sql and pl/sql wrapper cursors are still shared -- Change a bind variable type: var v number begin select count(5) into :v from dual; end; / ADDRESS SQL_TEXT 6DE92A74 SELECT count(5) from dual 6DE960D0 begin select count(5) into :v from dual; end; 6DE960D0 begin select count(5) into :v from dual; end; -- ok, here pl/sql parent (dep=0) cursor is no longer shared [EMAIL PROTECTED] select * from v$sql_shared_cursor where kglhdpar = '6DE960D0'; ADDRESS KGLHDPAR U S O O S L S E B P I S T A B D L T R I I R L I O S M U T N F - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 6DE95B54 6DE960D0 N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N 6DE86F94 6DE960D0 N N N N N N N N N N N N N N Y N N N N N N N N N N N N N N N N 2 rows selected. -- yep, bind variables mismatch Thanks, Boris Dali. --- Jonathan Lewis [EMAIL PROTECTED] wrote: I recall James Morle saying something about code not being sharable if the declared sizes of the bind variables don't match. If Informatica is using a 3GL to call anonymous pl/sql blocks with different bind variables every time, perhaps it is causing a bind variable mismatch. As for the 400MB - I've often noticed oddities where a new entry is created, but carries forward a report of the memory requirements of earlier variants, so if you have 10 cursors, they don't report 10 units of memory, but 1 + 2 + 3 + 4 + 5 + 6 + 7 + 8 + 9 + 10 units. It is possible that you are seeing some effect like this. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November 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] Sent: Tuesday, December 23, 2003 5:09 PM Thomas, The version count is the number of child cursors present in the cache for this SQL. The cursor is not being shared for some reason with 456 versions. The 400m of memory seems a bit excessive. There is a script at Jonathan's site with some info about v$sqlarea and a script you can run that looks at the current memory requirements for a SQL statement. http://www.jlcomp.demon.co.uk/sqlarea.html Does the output match what you see in statspack? Also, the number of executions is much lower than the version count, which is rather odd. There's a bug in early 9i versions that would cause this, but was supposed to be corrected by 9.2.0.2. In experimenting with this, I managed to get 4 different sessions to create 2 versions of a cursor. I'm not sure why as it was pl/sql and variables were used for the calling parameters. A 'select * from v$sql_shared_cursor' did not reveal any reason for it. After bouncing the database and trying this again, I couldn't duplicate it. Maybe a couple of things to pursue here, but perhaps not an abundance of help. :( Jared On Tue, 2003-12-23 at 04:44, Thomas Jeff wrote: Jared, Digging into it more, I found out that it's called from an Informatica client. Apparently, the gist of the client-side algorithim is as follows: For each row in (some view) Call generate_product_keys MERGE (upsert) into product table end loop -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: STATSPACK interpretation
Notes in-line. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November 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] Sent: Tuesday, December 23, 2003 8:44 PM Jonathan, Wouldn't bind variable issue that prevents cursor from sharing be visible in bind_mismatch? I would certainly hope so - but I remember playing around with v$sql_shared_cursor when it first came out and find cases where un-shared cursors came up with a full set of N's in the view. How can one simulate this? var v varchar2(1) begin select count(5) into :v from dual; end; / select address, sql_text from v$sql where sql_text like '%count(5)%'; ADDRESS SQL_TEXT -- - 6DE92A74 SELECT count(5) from dual 6DE960D0 begin select count(5) into :v from dual; end; -- Change a bind variable size: var v varchar2(30) begin select count(5) into :v from dual; end; / -- same output, no change, both sql and pl/sql wrapper cursors are still shared Nicely done. I think I'd run event 10046 at level 4 as well to get the bind variable dumps and check if the the SQL (or pl/sql) environment was ignoring the MAXLEN value for your variables. There are a few places where 'special optimisations' exist in Oracle's internal coding. You might also try it with the most extreme case - it may be (for example) that Oracle rounds up varchar2() variables to 32 bytes - I'd go for 1 and 4000 - just in case. -- Change a bind variable type: var v number begin select count(5) into :v from dual; end; / ADDRESS SQL_TEXT -- -- 6DE92A74 SELECT count(5) from dual 6DE960D0 begin select count(5) into :v from dual; end; 6DE960D0 begin select count(5) into :v from dual; end; -- ok, here pl/sql parent (dep=0) cursor is no longer shared [EMAIL PROTECTED] select * from v$sql_shared_cursor where kglhdpar = '6DE960D0'; ADDRESS KGLHDPAR U S O O S L S E B P I S T A B D L T R I I R L I O S M U T N F - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 6DE95B54 6DE960D0 N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N 6DE86F94 6DE960D0 N N N N N N N N N N N N N N Y N N N N N N N N N N N N N N N N 2 rows selected. -- yep, bind variables mismatch Thanks, Boris Dali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: STATSPACK interpretation
FWIW. The database crashed again.I managed to get in a 10466: BEGIN GENERATE_PRODUCT_KEYS (:1,:2,:3,:4) ; END; call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 2737 1213.001184.60 0 0 0 0 Execute 2737 28.57 28.08 0 0 0 2737 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 5474 1241.571212.68 0 0 0 2737 Looks like maybe that it's an anonymous PL/SQL call just as Jonathan described? Thanks for the replies. -Original Message- Jared Still Sent: Tuesday, December 23, 2003 2:34 PM To: Multiple recipients of list ORACLE-L Thanks Jonathan. I was wondering about those memory columns possibly acting in that manner. I've never used them to track memory though, and wasn't sure how they might act. Google and MetaLink didn't turn up anything too useful in the regard. Now that you mention it, I recall reading recently somewhere that different size bind variables could cause multiple versions. Probably James, but I can't recall where I saw it. Google, Metalinkm mailing lists and a plethora of books and white papers have made it quite difficult, at least for me, to always remember the source of tidbits such as this. Back to the memory, I was somehow able to cause 2 version of the same SQL, as mentioned earlier, but the reason for it did not appear in v$sql_shared_cursor. Jared On Tue, 2003-12-23 at 10:54, Jonathan Lewis wrote: I recall James Morle saying something about code not being sharable if the declared sizes of the bind variables don't match. If Informatica is using a 3GL to call anonymous pl/sql blocks with different bind variables every time, perhaps it is causing a bind variable mismatch. As for the 400MB - I've often noticed oddities where a new entry is created, but carries forward a report of the memory requirements of earlier variants, so if you have 10 cursors, they don't report 10 units of memory, but 1 + 2 + 3 + 4 + 5 + 6 + 7 + 8 + 9 + 10 units. It is possible that you are seeing some effect like this. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November 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] Sent: Tuesday, December 23, 2003 5:09 PM Thomas, The version count is the number of child cursors present in the cache for this SQL. The cursor is not being shared for some reason with 456 versions. The 400m of memory seems a bit excessive. There is a script at Jonathan's site with some info about v$sqlarea and a script you can run that looks at the current memory requirements for a SQL statement. http://www.jlcomp.demon.co.uk/sqlarea.html Does the output match what you see in statspack? Also, the number of executions is much lower than the version count, which is rather odd. There's a bug in early 9i versions that would cause this, but was supposed to be corrected by 9.2.0.2. In experimenting with this, I managed to get 4 different sessions to create 2 versions of a cursor. I'm not sure why as it was pl/sql and variables were used for the calling parameters. A 'select * from v$sql_shared_cursor' did not reveal any reason for it. After bouncing the database and trying this again, I couldn't duplicate it. Maybe a couple of things to pursue here, but perhaps not an abundance of help. :( Jared On Tue, 2003-12-23 at 04:44, Thomas Jeff wrote: Jared, Digging into it more, I found out that it's called from an Informatica client. Apparently, the gist of the client-side algorithim is as follows: For each row in (some view) Call generate_product_keys MERGE (upsert) into product table end loop -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
Re: STATSPACK interpretation
Thanks, Jonathan. Of course you are right :-) Playing with this a little longer, I can get up to 4 versions (child_number from 0 to 3) of the same pl/sql cursor by changing bind variable sizes. It ceases being sharable when bv size changes from 32 to 33, from 128 to 129 and from 2000 to 2001: 1-32 33-128 129-2000 2001-4000 I wonder if this behavior can be changed by some init settings? Thanks, Boris Dali. --- Jonathan Lewis [EMAIL PROTECTED] wrote: Notes in-line. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November 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] Sent: Tuesday, December 23, 2003 8:44 PM Jonathan, Wouldn't bind variable issue that prevents cursor from sharing be visible in bind_mismatch? I would certainly hope so - but I remember playing around with v$sql_shared_cursor when it first came out and find cases where un-shared cursors came up with a full set of N's in the view. How can one simulate this? var v varchar2(1) begin select count(5) into :v from dual; end; / select address, sql_text from v$sql where sql_text like '%count(5)%'; ADDRESS SQL_TEXT -- - 6DE92A74 SELECT count(5) from dual 6DE960D0 begin select count(5) into :v from dual; end; -- Change a bind variable size: var v varchar2(30) begin select count(5) into :v from dual; end; / -- same output, no change, both sql and pl/sql wrapper cursors are still shared Nicely done. I think I'd run event 10046 at level 4 as well to get the bind variable dumps and check if the the SQL (or pl/sql) environment was ignoring the MAXLEN value for your variables. There are a few places where 'special optimisations' exist in Oracle's internal coding. You might also try it with the most extreme case - it may be (for example) that Oracle rounds up varchar2() variables to 32 bytes - I'd go for 1 and 4000 - just in case. -- Change a bind variable type: var v number begin select count(5) into :v from dual; end; / ADDRESS SQL_TEXT -- -- 6DE92A74 SELECT count(5) from dual 6DE960D0 begin select count(5) into :v from dual; end; 6DE960D0 begin select count(5) into :v from dual; end; -- ok, here pl/sql parent (dep=0) cursor is no longer shared [EMAIL PROTECTED] select * from v$sql_shared_cursor where kglhdpar = '6DE960D0'; ADDRESS KGLHDPAR U S O O S L S E B P I S T A B D L T R I I R L I O S M U T N F - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 6DE95B54 6DE960D0 N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N 6DE86F94 6DE960D0 N N N N N N N N N N N N N N Y N N N N N N N N N N N N N N N N 2 rows selected. -- yep, bind variables mismatch Thanks, Boris Dali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
STATSPACK interpretation
Title: STATSPACK interpretation We recently experienced a crash on our prod datewarehouse running 9.2.0.2 on AIX 4.3.3. The cause of the crash was 4031 errors generated by background processes (Oracle support has confirmed there is a bug involved), however, since that crash occurred, a certain nightly batch job has slowed to a crawl. Trying to recreate what has happened, I came across this in the STATSPACK report. The interval for this report is 30 minutes. Is it telling me that I have 746 versions of this call eating up 400+ mb at the time of the snapshot? Why would that be? The procedure in question uses bind variables. SQL ordered by Sharable Memory for DB: DSSP Instance: DSSP Snaps: 3309 -3310 - End Sharable Memory Threshold: 1048576 Sharable Mem (b) Executions % Total Hash Value --- 483,580,268 57 411.8 539672786 Module: [EMAIL PROTECTED] (TNS V1-V3) BEGIN GENERATE_PRODUCT_KEYS (:1,:2,:3,:4) ; END; - SQL ordered by Version Count for DB: DSSP Instance: DSSP Snaps: 3309 -3310 - End Version Count Threshold: 20 Version Count Executions Hash Value 746 57 539672786 Module: [EMAIL PROTECTED] (TNS V1-V3) BEGIN GENERATE_PRODUCT_KEYS (:1,:2,:3,:4) ; END; Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba
Re: STATSPACK interpretation
What is taking place inside GENERATE_PRODUCT_KEYS() ? Could be dynamic SQL of the worst kind in there. That is, not using bind variables. A 10046 trace level 4 or 12 will show you what is going on there. Jared On Mon, 2003-12-22 at 12:39, Thomas Jeff wrote: We recently experienced a crash on our prod datewarehouse running 9.2.0.2 on AIX 4.3.3.The cause of the crash was 4031 errors generated by background processes (Oracle support has confirmed there is a bug involved), however, since that crash occurred, a certain nightly batch job has slowed to a crawl. Trying to recreate what has happened, I came across this in the STATSPACK report. The interval for this report is 30 minutes. Is it telling me that I have 746 versions of this call eating up 400+ mb at the time of the snapshot? Why would that be? The procedure in question uses bind variables. SQL ordered by Sharable Memory for DB: DSSP Instance: DSSP Snaps: 3309 -3310 - End Sharable Memory Threshold: 1048576 Sharable Mem (b) Executions % Total Hash Value --- 483,580,268 57 411.8539672786 Module: [EMAIL PROTECTED] (TNS V1-V3) BEGINGENERATE_PRODUCT_KEYS (:1,:2,:3,:4) ; END; - SQL ordered by Version Count for DB: DSSP Instance: DSSP Snaps: 3309 -3310 - End Version Count Threshold:20 Version Count Executions Hash Value 746 57539672786 Module: [EMAIL PROTECTED] (TNS V1-V3) BEGINGENERATE_PRODUCT_KEYS (:1,:2,:3,:4) ; END; Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
SQL_Trace versus Statspack
We are doing Interest processing on a SET of 10,000 Bank A/cs using a Single Database connect process. SQL Query :- select field names,rowid into :b0,:b1,... from TBA_ENTITY_INTEREST_TBL where (entity_id=:b105 and entity_type=:b106) for update of same (above) field names nowait; Above SQL Query Shows DIFFERING values (taken concurrently) for:- Execute from SQL_TRACE = 2584 Executions from Statspack report = 10,000 Qs. What is the reason for this? Qs. Have we possibly missed some SQL trace files? SQL_TRACE :- call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 2584 0.55 0.55 0 10475 2783 0 Fetch 2584 0.50 0.51 0 0 0 2584 --- -- -- -- -- -- -- total 5169 1.05 1.06 0 10475 2783 2584 Statspack :- CPU Elapsd Buffer GetsExecutions Gets per Exec %Total Time (s) Time (s) Hash Value --- -- -- - -- 51,271 10,0005.1 23.0 4.31 3.95 1862033429 Module: [EMAIL PROTECTED] (TNS V1-V3) select TO_CHAR(accrued_upto_date_cr,'DD-MM- HH24:MI:SS') ,TO _CHAR(accrued_upto_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(las t_accrual_run_date_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(last_acc rual_run_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_d ate_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_date_dr,'DD NOTE - Actual SQL Query partly visible above too in statspack Output Will provide any data needed Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: SQL_Trace versus Statspack
Vivek, as others have pointed out before, Statspack is instance wide snapshot. Trace file is session specific. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, November 19, 2003 5:40 AM To: Multiple recipients of list ORACLE-L We are doing Interest processing on a SET of 10,000 Bank A/cs using a Single Database connect process. SQL Query :- select field names,rowid into :b0,:b1,... from TBA_ENTITY_INTEREST_TBL where (entity_id=:b105 and entity_type=:b106) for update of same (above) field names nowait; Above SQL Query Shows DIFFERING values (taken concurrently) for:- Execute from SQL_TRACE = 2584 Executions from Statspack report = 10,000 Qs. What is the reason for this? Qs. Have we possibly missed some SQL trace files? SQL_TRACE :- call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 2584 0.55 0.55 0 10475 2783 0 Fetch 2584 0.50 0.51 0 0 0 2584 --- -- -- -- -- -- -- total 5169 1.05 1.06 0 10475 2783 2584 Statspack :- CPU Elapsd Buffer GetsExecutions Gets per Exec %Total Time (s) Time (s) Hash Value --- -- -- - -- 51,271 10,0005.1 23.0 4.31 3.95 1862033429 Module: [EMAIL PROTECTED] (TNS V1-V3) select TO_CHAR(accrued_upto_date_cr,'DD-MM- HH24:MI:SS') ,TO _CHAR(accrued_upto_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(las t_accrual_run_date_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(last_acc rual_run_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_d ate_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_date_dr,'DD NOTE - Actual SQL Query partly visible above too in statspack Output Will provide any data needed Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). ** 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 corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: SQL_Trace versus Statspack
Vivek did mention single DB connect process, so this should increase the possibility of statspack matching the trace file Did you have parallel query occurring - as then the single trace wouldn't have caught everything. Are you SURE no other users were active at the same time - eg look at logons cumulative in v$sysstat Were the trace and snapshot for the EXACT same time interval? HTH, Bruce Reardon NOTICE: This e-mail and any attachments are private and confidential and may contain legally privileged information. If you are not an authorised recipient, the copying or distribution of this e-mail and any attachments is prohibited and you must not read, print or act in reliance on this e-mail or attachments. This notice should not be removed. -Original Message- Sent: Thursday, 20 November 2003 12:15 AM To: Multiple recipients of list ORACLE-L Vivek, as others have pointed out before, Statspack is instance wide snapshot. Trace file is session specific. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, November 19, 2003 5:40 AM To: Multiple recipients of list ORACLE-L We are doing Interest processing on a SET of 10,000 Bank A/cs using a Single Database connect process. SQL Query :- select field names,rowid into :b0,:b1,... from TBA_ENTITY_INTEREST_TBL where (entity_id=:b105 and entity_type=:b106) for update of same (above) field names nowait; Above SQL Query Shows DIFFERING values (taken concurrently) for:- Execute from SQL_TRACE = 2584 Executions from Statspack report = 10,000 Qs. What is the reason for this? Qs. Have we possibly missed some SQL trace files? SQL_TRACE :- call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 2584 0.55 0.55 0 10475 2783 0 Fetch 2584 0.50 0.51 0 0 0 2584 --- -- -- -- -- -- -- total 5169 1.05 1.06 0 10475 2783 2584 Statspack :- CPU Elapsd Buffer GetsExecutions Gets per Exec %Total Time (s) Time (s) Hash Value --- -- -- - -- 51,271 10,0005.1 23.0 4.31 3.95 1862033429 Module: [EMAIL PROTECTED] (TNS V1-V3) select TO_CHAR(accrued_upto_date_cr,'DD-MM- HH24:MI:SS') ,TO _CHAR(accrued_upto_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(las t_accrual_run_date_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(last_acc rual_run_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_d ate_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_date_dr,'DD NOTE - Actual SQL Query partly visible above too in statspack Output Will provide any data needed Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). ** 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 corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
RE: Trace (SQL) versus Statspack data
We are doing Interest processing on a SET of 10,000 Bank A/cs SQL Query :- select field names,rowid into :b0,:b1,... from TBA_ENTITY_INTEREST_TBL where (entity_id=:b105 and entity_type=:b106) for update of same (above) field names nowait; Above SQL Query Shows DIFFERING values (taken concurrently) for:- Execute from SQL_TRACE = 2584 Executions from Statspack report = 10,000 Qs. What is the reason for this? SQL_TRACE :- call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 2584 0.55 0.55 0 10475 2783 0 Fetch 2584 0.50 0.51 0 0 0 2584 --- -- -- -- -- -- -- total 5169 1.05 1.06 0 10475 2783 2584 Statspack :- CPU Elapsd Buffer GetsExecutions Gets per Exec %Total Time (s) Time (s) Hash Value --- -- -- - -- 51,271 10,0005.1 23.0 4.31 3.95 1862033429 Module: [EMAIL PROTECTED] (TNS V1-V3) select TO_CHAR(accrued_upto_date_cr,'DD-MM- HH24:MI:SS') ,TO _CHAR(accrued_upto_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(las t_accrual_run_date_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(last_acc rual_run_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_d ate_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_date_dr,'DD NOTE - Actual SQL Query partly visible above too in statspack Output Will provide any data needed Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Trace versus Statspack data
Hi. Execute in sqltrace is for that particular session only whereas in statspack, it's system wide. A lot of sessions might have executed the same query. Best regards VIVEK_SHARMA [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/17/2003 02:19 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Rhojel Echano/Manila/PH/SGS) Subject:Trace versus Statspack data We are doing Interest processing on a SET of 10,000 Bank A/cs Following SQL Query Shows DIFFERING values for :- "Execute" from SQL_TRACE = 2584 "Executions" from Statspack report = 10,000 Qs. What is the reason for this? SQL_TRACE :- call countcpu elapseddisk query currentrows --- -- -- -- -- -- -- Parse1 0.000.00 0 0 0 0 Execute 2584 0.550.55 0 104752783 0 Fetch 2584 0.500.51 0 0 02584 --- -- -- -- -- -- -- total 5169 1.051.06 0 1047527832584 Statspack :- CPU Elapsd Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value --- -- -- - -- 51,27110,000 5.1 23.0 4.31 3.95 1862033429 Module: [EMAIL PROTECTED] (TNS V1-V3) select TO_CHAR(accrued_upto_date_cr,'DD-MM- HH24:MI:SS') ,TO _CHAR(accrued_upto_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(las t_accrual_run_date_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(last_acc rual_run_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_d ate_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_date_dr,'DD Thanks
Trace versus Statspack data
We are doing Interest processing on a SET of 10,000 Bank A/cs Following SQL Query Shows DIFFERING values for :- Execute from SQL_TRACE = 2584 Executions from Statspack report = 10,000 Qs. What is the reason for this? SQL_TRACE :- call count cpu elapsed disk query current rows --- -- -- -- -- -- -- Parse 1 0.00 0.00 0 0 0 0 Execute 2584 0.55 0.55 0 10475 2783 0 Fetch 2584 0.50 0.51 0 0 0 2584 --- -- -- -- -- -- -- total 5169 1.05 1.06 0 10475 2783 2584 Statspack :- CPU Elapsd Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value --- -- -- - -- 51,271 10,000 5.1 23.0 4.31 3.95 1862033429 Module: [EMAIL PROTECTED] (TNS V1-V3) select TO_CHAR(accrued_upto_date_cr,'DD-MM- HH24:MI:SS') ,TO _CHAR(accrued_upto_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(las t_accrual_run_date_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(last_acc rual_run_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_d ate_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_date_dr,'DD Thanks
Trace versus Statspack data
We are doing Interest processing on a SET of 10,000 Bank A/cs Following SQL Query Shows DIFFERING values for :- Execute from SQL_TRACE = 2584 Executions from Statspack report = 10,000 Qs. What is the reason for this? SQL_TRACE :- call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 2584 0.55 0.55 0 10475 2783 0 Fetch 2584 0.50 0.51 0 0 0 2584 --- -- -- -- -- -- -- total 5169 1.05 1.06 0 10475 2783 2584 Statspack :- CPU Elapsd Buffer GetsExecutions Gets per Exec %Total Time (s) Time (s) Hash Value --- -- -- - -- 51,271 10,0005.1 23.0 4.31 3.95 1862033429 Module: [EMAIL PROTECTED] (TNS V1-V3) select TO_CHAR(accrued_upto_date_cr,'DD-MM- HH24:MI:SS') ,TO _CHAR(accrued_upto_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(las t_accrual_run_date_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(last_acc rual_run_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_d ate_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_date_dr,'DD Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Trace versus Statspack data
We are doing Interest processing on a SET of 10,000 Bank A/cs Following SQL Query Shows DIFFERING values for :- Execute from SQL_TRACE = 2584 Executions from Statspack report = 10,000 Qs. What is the reason for this? SQL_TRACE :- call count cpu elapsed disk query current rows --- -- -- -- -- -- -- Parse 1 0.00 0.00 0 0 0 0 Execute 2584 0.55 0.55 0 10475 2783 0 Fetch 2584 0.50 0.51 0 0 0 2584 --- -- -- -- -- -- -- total 5169 1.05 1.06 0 10475 2783 2584 Statspack :- CPU Elapsd Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value --- -- -- - -- 51,271 10,000 5.1 23.0 4.31 3.95 1862033429 Module: [EMAIL PROTECTED] (TNS V1-V3) select TO_CHAR(accrued_upto_date_cr,'DD-MM- HH24:MI:SS') ,TO _CHAR(accrued_upto_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(las t_accrual_run_date_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(last_acc rual_run_date_dr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_d ate_cr,'DD-MM- HH24:MI:SS') ,TO_CHAR(booked_upto_date_dr,'DD Thanks
Re: Statspack Report!
Title: Re: Statspack Report! Without looking at other parts of the report, there is no way of telling if this information is important or not. There is not enough timing information displayed to understand whether these issues are a significant part of your databases performance or not. Please upload your report to http://www.oraperf.com to get a much better organized analysis of the STATSPACK info. Youll need to register but it is worth it, although Veritas has unfortunately become much more aggressive about spam than Precise ever was. For instructions on how to read the results of the YAPP report, please read Bjorns paper on using STATSPACK with YAPP at http://oraperf.veritas.com/whitepapers.html... on 9/29/03 9:29 PM, Gunnar Berglund at [EMAIL PROTECTED] wrote: Hi all, could you please clarify me what these might mean (and how to tune the db in order to avoid those). So I have done a performance report with statspack and the instance is 9.2.0.3 on Solaris8 box. On a report there are a couple of issues I don't understand: Child Get Spin Latch Name Num Requests Misses Sleeps Sleeps 1-4 -- --- --- -- cache buffers chains 609 750,125 572 58 0/0/0/0/0 cache buffers chains 610 641,794 673 38 0/0/0/0/0 cache b! uffers chains 611 508,147 246 23 0/0/0/0/0 cache buffers chains 608 374,928 96 11 0/0/0/0/0 and Top 5 Timed Events ~~ % Total Event Waits Time (s) Ela Time --- direct path write (lob) 101,116 ! 13,637 38.23 and Event Waits Timeouts Time (s) (ms) /txn -- -- -- rdbms ipc message 218,281 202,375 809,339 3708 0.8 Sorry for the mess, but please try to read... TIA gb Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.com/
Statspack Report!
Hi all, could you please clarify me what these might mean (and how to tune the db in order to avoid those). So I have done a performance report with statspack and the instance is 9.2.0.3 on Solaris8 box. On a report there are a couple of issues I don't understand: Child Get Spin Latch Name Num Requests Misses Sleeps Sleeps 1-4-- --- --- -- cache buffers chains 609 750,125 572 58 0/0/0/0/0cache buffers chains 610 641,794 673 38 0/0/0/0/0cache buffers chains 611 508,147 246 23 0/0/0/0/0cache buffers chains 608 374,928 96 11 0/0/0/0/0 and Top 5 Timed Events~~ % TotalEvent Waits Time (s) Ela Time --- direct path write (lob) 101,116 13,637 38.23 and Event Waits Timeouts Time (s) (ms) /txn -- -- -- rdbms ipc message 218,281 202,375 809,339 3708 0.8 Sorry for the mess, but please try to read... TIA gbWant to chat instantly with your online friends? Get the FREE Yahoo! Messenger
Re: STATSPACK in Oracle 8.1.6.0
Hi Scott, Although the recommendation of RTFM often has it's merits, where precisely do you suggest Seema should look for the above mentioned FM within the *8.1.6* doco set for the sp* statspack scripts ? Cheers Richard Foote - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 18, 2003 5:59 AM RTFM, which will point you to the sp*.sql scripts in the ?/rdbms/admin directory. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 2:49 PM To: Multiple recipients of list ORACLE-L Subject: STATSPACK in Oracle 8.1.6.0 Hi, I want to delete all old records of statspack from perfstat schema. What would be best way to do this either by truncating all tables or remove and recreate ? Pl advice. thx -Seema _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: STATSPACK in Oracle 8.1.6.0
Metalink, Technet, Google, or at the scripts themselves (which all have explanatory headers). Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Richard Foote [SMTP:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 5:34 AM To: Multiple recipients of list ORACLE-L Subject: Re: STATSPACK in Oracle 8.1.6.0 Hi Scott, Although the recommendation of RTFM often has it's merits, where precisely do you suggest Seema should look for the above mentioned FM within the *8.1.6* doco set for the sp* statspack scripts ? Cheers Richard Foote - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 18, 2003 5:59 AM RTFM, which will point you to the sp*.sql scripts in the ?/rdbms/admin directory. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 2:49 PM To: Multiple recipients of list ORACLE-L Subject: STATSPACK in Oracle 8.1.6.0 Hi, I want to delete all old records of statspack from perfstat schema. What would be best way to do this either by truncating all tables or remove and recreate ? Pl advice. thx -Seema _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
STATSPACK in Oracle 8.1.6.0
Hi, I want to delete all old records of statspack from perfstat schema. What would be best way to do this either by truncating all tables or remove and recreate ? Pl advice. thx -Seema _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: STATSPACK in Oracle 8.1.6.0
The latter. Scripts are already supplied. - Kirti --- Seema Singh [EMAIL PROTECTED] wrote: Hi, I want to delete all old records of statspack from perfstat schema. What would be best way to do this either by truncating all tables or remove and recreate ? Pl advice. thx -Seema _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Deleting Statspack tables.
Not quite true that my stuff has been moved; just copied. Think of cp instead of mv commands... on 6/11/03 3:49 AM, Ranganath K at [EMAIL PROTECTED] wrote: Hi John, Tim Gorman's site has been moved to http://www.sagelogix.com. So one can find all the UNIX and SQL scripts in sagelogix.com rather than evbdt.com. Regards, Ranganath -Original Message- Sent: Wednesday, June 11, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Tim Gorman has produced an excellent package sppurpkg.sql which certainly does the business for me It can be found at http://www.evdbt.com/sppurpkg.sql John -Original Message- Sent: 11 June 2003 00:35 To: Multiple recipients of list ORACLE-L Version : 8.1.7.3. I am not sure how it is working for you just by deleting from stats$snapshot and we do not have 8.1.6 here. Thanks -Original Message- Sent: Tuesday, June 10, 2003 4:40 PM To: Multiple recipients of list ORACLE-L Reddy - You didn't mention your Oracle version. I am on 8.1.6 and I don't think those scripts are available there (sorry, busy day, no time to research). So I just delete from stats$snapshot. It seems to remove data from the associated tables just fine. First I select the snap_id and snap_time from stats$snapshot to determine which snapshots to remove. It runs slowly (because of all the child tables?), so I just remove a hundred or so at a time. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 10, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Hello All, We have a job ( shell Script ) which deletes from the statspack tables every Sunday, but uses SPPURGE.sql ( $ORACLE_HOME/rdbms/admin). Seems like it is not deleting all tables and hence causing the tablespace to grow. Does anybody has a different approach which deletes all table without any referential integrity issues ?? I do not want to use SPTRUNC.sql please. Pl find below some of the statspack tables are growing so big ( also Indexes /PKs ). STATS$BG_EVENT_SUMMARY 7 STATS$ROWCACHE_SUMMARY 8 STATS$SGASTAT 8 STATS$LATCH_PARENT 10 STATS$SYSTEM_EVENT 19 STATS$ROLLSTAT 37 STATS$LATCH50 STATS$SYSSTAT 51 TABLE Size in MB -- -- STATS$PARAMETER56 STATS$LATCH_MISSES_SUMMARY 84 STATS$SQLTEXT 122 STATS$FILESTATXS 234 STATS$SQL_SUMMARY 886 STATS$LATCH_CHILDREN 2872 ( These are just tables , didnt show indexes here) Thank You , Madhu Reddy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Deleting Statspack tables.
Tim Gorman has produced an excellent package sppurpkg.sql which certainly does the business for me It can be found at http://www.evdbt.com/sppurpkg.sql John -Original Message- Sent: 11 June 2003 00:35 To: Multiple recipients of list ORACLE-L Version : 8.1.7.3. I am not sure how it is working for you just by deleting from stats$snapshot and we do not have 8.1.6 here. Thanks -Original Message- Sent: Tuesday, June 10, 2003 4:40 PM To: Multiple recipients of list ORACLE-L Reddy - You didn't mention your Oracle version. I am on 8.1.6 and I don't think those scripts are available there (sorry, busy day, no time to research). So I just delete from stats$snapshot. It seems to remove data from the associated tables just fine. First I select the snap_id and snap_time from stats$snapshot to determine which snapshots to remove. It runs slowly (because of all the child tables?), so I just remove a hundred or so at a time. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 10, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Hello All, We have a job ( shell Script ) which deletes from the statspack tables every Sunday, but uses SPPURGE.sql ( $ORACLE_HOME/rdbms/admin). Seems like it is not deleting all tables and hence causing the tablespace to grow. Does anybody has a different approach which deletes all table without any referential integrity issues ?? I do not want to use SPTRUNC.sql please. Pl find below some of the statspack tables are growing so big ( also Indexes /PKs ). STATS$BG_EVENT_SUMMARY 7 STATS$ROWCACHE_SUMMARY 8 STATS$SGASTAT 8 STATS$LATCH_PARENT 10 STATS$SYSTEM_EVENT 19 STATS$ROLLSTAT 37 STATS$LATCH50 STATS$SYSSTAT 51 TABLE Size in MB -- -- STATS$PARAMETER56 STATS$LATCH_MISSES_SUMMARY 84 STATS$SQLTEXT 122 STATS$FILESTATXS 234 STATS$SQL_SUMMARY 886 STATS$LATCH_CHILDREN 2872 ( These are just tables , didnt show indexes here) Thank You , Madhu Reddy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Deleting Statspack tables.
Hi John, Tim Gorman's site has been moved to http://www.sagelogix.com. So one can find all the UNIX and SQL scripts in sagelogix.com rather than evbdt.com. Regards, Ranganath -Original Message- Sent: Wednesday, June 11, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Tim Gorman has produced an excellent package sppurpkg.sql which certainly does the business for me It can be found at http://www.evdbt.com/sppurpkg.sql John -Original Message- Sent: 11 June 2003 00:35 To: Multiple recipients of list ORACLE-L Version : 8.1.7.3. I am not sure how it is working for you just by deleting from stats$snapshot and we do not have 8.1.6 here. Thanks -Original Message- Sent: Tuesday, June 10, 2003 4:40 PM To: Multiple recipients of list ORACLE-L Reddy - You didn't mention your Oracle version. I am on 8.1.6 and I don't think those scripts are available there (sorry, busy day, no time to research). So I just delete from stats$snapshot. It seems to remove data from the associated tables just fine. First I select the snap_id and snap_time from stats$snapshot to determine which snapshots to remove. It runs slowly (because of all the child tables?), so I just remove a hundred or so at a time. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 10, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Hello All, We have a job ( shell Script ) which deletes from the statspack tables every Sunday, but uses SPPURGE.sql ( $ORACLE_HOME/rdbms/admin). Seems like it is not deleting all tables and hence causing the tablespace to grow. Does anybody has a different approach which deletes all table without any referential integrity issues ?? I do not want to use SPTRUNC.sql please. Pl find below some of the statspack tables are growing so big ( also Indexes /PKs ). STATS$BG_EVENT_SUMMARY 7 STATS$ROWCACHE_SUMMARY 8 STATS$SGASTAT 8 STATS$LATCH_PARENT 10 STATS$SYSTEM_EVENT 19 STATS$ROLLSTAT 37 STATS$LATCH50 STATS$SYSSTAT 51 TABLE Size in MB -- -- STATS$PARAMETER56 STATS$LATCH_MISSES_SUMMARY 84 STATS$SQLTEXT 122 STATS$FILESTATXS 234 STATS$SQL_SUMMARY 886 STATS$LATCH_CHILDREN 2872 ( These are just tables , didnt show indexes here) Thank You , Madhu Reddy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Hallas, John, Tech Dev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E
RE: Deleting Statspack tables.
Tim's script is not much of different except deleting from the stats$sqltext from original SPPURGE.sql . But if you see my mail below I do have a lot of other tables which needs to be purged periodically. Thank You, Madhu Reddy -Original Message- Sent: Tuesday, June 10, 2003 9:50 PM To: Multiple recipients of list ORACLE-L Um, if I understand correctly, you're just trying to keep the volume down in your statspack tables. I use Tim Gorman's sppurpkg.sql package (on several different versions across several different operating systems). (www.evdbt.com) I have it set up to keep 14 days of data, but you can change that. It schedules the dbms_job for you. I just set up his job when I configure statspack on a new database, and then I never need to think about it again. You might take a look and see if it'll work for you. Barb --- Reddy, Madhusudana [EMAIL PROTECTED] wrote: Hello All, We have a job ( shell Script ) which deletes from the statspack tables every Sunday, but uses SPPURGE.sql ( $ORACLE_HOME/rdbms/admin). Seems like it is not deleting all tables and hence causing the tablespace to grow. Does anybody has a different approach which deletes all table without any referential integrity issues ?? I do not want to use SPTRUNC.sql please. Pl find below some of the statspack tables are growing so big ( also Indexes /PKs ). STATS$BG_EVENT_SUMMARY 7 STATS$ROWCACHE_SUMMARY 8 STATS$SGASTAT 8 STATS$LATCH_PARENT 10 STATS$SYSTEM_EVENT 19 STATS$ROLLSTAT 37 STATS$LATCH50 STATS$SYSSTAT 51 TABLE Size in MB -- -- STATS$PARAMETER56 STATS$LATCH_MISSES_SUMMARY 84 STATS$SQLTEXT 122 STATS$FILESTATXS 234 STATS$SQL_SUMMARY 886 STATS$LATCH_CHILDREN 2872 ( These are just tables , didnt show indexes here) Thank You , Madhu Reddy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Deleting Statspack tables.
I'm having difficulty following all of the referential integrity on perfstat tables, but there are several on delete cascade constraints on the tables. It looks to me like all of my perfstat tables are being cleaned up. I've been accumulating data on 1 database for more than 1 year every hour at level 5, and my largest table is 10 megs. It's very odd that your STATS$LATCH_CHILDREN table is nearly 3 gigs. I have to wonder if something else is wrong. You might check your perfstat user to insure that the user has adequate privs; you might even consider removing and re-installing statspack. Good luck! Barb --- Reddy, Madhusudana [EMAIL PROTECTED] wrote: Tim's script is not much of different except deleting from the stats$sqltext from original SPPURGE.sql . But if you see my mail below I do have a lot of other tables which needs to be purged periodically. Thank You, Madhu Reddy -Original Message- Sent: Tuesday, June 10, 2003 9:50 PM To: Multiple recipients of list ORACLE-L Um, if I understand correctly, you're just trying to keep the volume down in your statspack tables. I use Tim Gorman's sppurpkg.sql package (on several different versions across several different operating systems). (www.evdbt.com) I have it set up to keep 14 days of data, but you can change that. It schedules the dbms_job for you. I just set up his job when I configure statspack on a new database, and then I never need to think about it again. You might take a look and see if it'll work for you. Barb --- Reddy, Madhusudana [EMAIL PROTECTED] wrote: Hello All, We have a job ( shell Script ) which deletes from the statspack tables every Sunday, but uses SPPURGE.sql ( $ORACLE_HOME/rdbms/admin). Seems like it is not deleting all tables and hence causing the tablespace to grow. Does anybody has a different approach which deletes all table without any referential integrity issues ?? I do not want to use SPTRUNC.sql please. Pl find below some of the statspack tables are growing so big ( also Indexes /PKs ). STATS$BG_EVENT_SUMMARY 7 STATS$ROWCACHE_SUMMARY 8 STATS$SGASTAT 8 STATS$LATCH_PARENT 10 STATS$SYSTEM_EVENT 19 STATS$ROLLSTAT 37 STATS$LATCH50 STATS$SYSSTAT 51 TABLE Size in MB -- -- STATS$PARAMETER56 STATS$LATCH_MISSES_SUMMARY 84 STATS$SQLTEXT 122 STATS$FILESTATXS 234 STATS$SQL_SUMMARY 886 STATS$LATCH_CHILDREN 2872 ( These are just tables , didnt show indexes here) Thank You , Madhu Reddy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
RE: any intro statspack docs online?
Search MetaLink ... Burleson has a good book "High PerformanceTuning with Statspack" .. Tom Kytes Book "Oneon One" in Chapter 10 also hassome good information.. Look in your $ORACLE_HOME/rdbms/admin and depending on you version their is a sp*.doc or st*.txt document in there to show you how to set up and use. Also, I think Tim Gorman's site has some statspack stuffin his downloadable library section. http://www.evdbt.com/ HTH, Mike -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]Sent: Monday, June 09, 2003 10:00 AMTo: Multiple recipients of list ORACLE-LSubject: Re: any intro statspack docs online? I know it is late but: Since nobody mention it - upload the report to http://www.oraperf.com/ and you will get a report with explanation and recommendations. Yechiel AdarMehish - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, May 22, 2003 5:41 PM Subject: any intro statspack docs online? Ive read the otn stuff and the niemic articles from Oracle mag.anything else? any articles that give a brief intro that includes installation? Id prefer not to dig into the Burleson book. Im really looking for something brief.Not too familiar with tuning wait events, but I 'think' we have some contention problems, and before I create an elaborate routine, Id like to get some metrics. any quick start guide? Licensing is based on customers honesty basically. The versions you can download are fully functional with all the options. Visit our web site at http://www.quantsystems.nl/ -Original Message-From: Joe Joe [mailto:[EMAIL PROTECTED] Sent: Thursday, May 22, 2003 11:37 AMTo: Multiple recipients of list ORACLE-LSubject: oracle trialware - features ?? Folks, Does "Oracle Enterprise Edition - Trialware" have all the features as that of alicensedone ? Is RMAN fully functional on a trial version of 9iR2 ? What makes the difference between these two ? If there is no difference, how does ORACLE prevent people from using it for PRODUCTION ? Read an interesting article about oracle licensing at http://www.vnunet.com/Analysis/1113993 and just thought of sharing it with u guys. Share your comments Gurus. Cheers, Joe. Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!Login To Lycos Mail
RE: any intro statspack docs online?
check these links http://www.oracle.com/oramag/oracle/00-Mar/o20tun.html http://www.oracle.com/oramag/oracle/00-Sep/o50tun.html http://www.oracle.com/oramag/oracle/00-Nov/o60tun.html http://www.oracle.com/oramag/oracle/00-Nov/o60tun_ol.html Dave -Original Message-From: Johnson, Michael [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 10, 2003 12:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: any intro statspack docs online? Search MetaLink ... Burleson has a good book "High PerformanceTuning with Statspack" .. Tom Kytes Book "Oneon One" in Chapter 10 also hassome good information.. Look in your $ORACLE_HOME/rdbms/admin and depending on you version their is a sp*.doc or st*.txt document in there to show you how to set up and use. Also, I think Tim Gorman's site has some statspack stuffin his downloadable library section. http://www.evdbt.com/ HTH, Mike -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]Sent: Monday, June 09, 2003 10:00 AMTo: Multiple recipients of list ORACLE-LSubject: Re: any intro statspack docs online? I know it is late but: Since nobody mention it - upload the report to http://www.oraperf.com/ and you will get a report with explanation and recommendations. Yechiel AdarMehish - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, May 22, 2003 5:41 PM Subject: any intro statspack docs online? Ive read the otn stuff and the niemic articles from Oracle mag.anything else? any articles that give a brief intro that includes installation? Id prefer not to dig into the Burleson book. Im really looking for something brief.Not too familiar with tuning wait events, but I 'think' we have some contention problems, and before I create an elaborate routine, Id like to get some metrics. any quick start guide? Licensing is based on customers honesty basically. The versions you can download are fully functional with all the options. Visit our web site at http://www.quantsystems.nl/ -Original Message-From: Joe Joe [mailto:[EMAIL PROTECTED] Sent: Thursday, May 22, 2003 11:37 AMTo: Multiple recipients of list ORACLE-LSubject: oracle trialware - features ?? Folks, Does "Oracle Enterprise Edition - Trialware" have all the features as that of alicensedone ? Is RMAN fully functional on a trial version of 9iR2 ? What makes the difference between these two ? If there is no difference, how does ORACLE prevent people from using it for PRODUCTION ? Read an interesting article about oracle licensing at http://www.vnunet.com/Analysis/1113993 and just thought of sharing it with u guys. Share your comments Gurus. Cheers, Joe. Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!Login To Lycos Mail
Deleting Statspack tables.
Hello All, We have a job ( shell Script ) which deletes from the statspack tables every Sunday, but uses SPPURGE.sql ( $ORACLE_HOME/rdbms/admin). Seems like it is not deleting all tables and hence causing the tablespace to grow. Does anybody has a different approach which deletes all table without any referential integrity issues ?? I do not want to use SPTRUNC.sql please. Pl find below some of the statspack tables are growing so big ( also Indexes /PKs ). STATS$BG_EVENT_SUMMARY 7 STATS$ROWCACHE_SUMMARY 8 STATS$SGASTAT 8 STATS$LATCH_PARENT 10 STATS$SYSTEM_EVENT 19 STATS$ROLLSTAT 37 STATS$LATCH50 STATS$SYSSTAT 51 TABLE Size in MB -- -- STATS$PARAMETER56 STATS$LATCH_MISSES_SUMMARY 84 STATS$SQLTEXT 122 STATS$FILESTATXS 234 STATS$SQL_SUMMARY 886 STATS$LATCH_CHILDREN 2872 ( These are just tables , didnt show indexes here) Thank You , Madhu Reddy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Deleting Statspack tables.
I know there are some versions that the sppurge doesn't remove rows from the children tables. I haven't noticed this since I got to 8.1.7.3 on Tru64. You can write a script to delete from the other tables where they don't have a record in the parent table and run it the same time as SPURGE. Stephen [EMAIL PROTECTED] 06/10/03 12:14PM Hello All, We have a job ( shell Script ) which deletes from the statspack tables every Sunday, but uses SPPURGE.sql ( $ORACLE_HOME/rdbms/admin). Seems like it is not deleting all tables and hence causing the tablespace to grow. Does anybody has a different approach which deletes all table without any referential integrity issues ?? I do not want to use SPTRUNC.sql please. Pl find below some of the statspack tables are growing so big ( also Indexes /PKs ). STATS$BG_EVENT_SUMMARY 7 STATS$ROWCACHE_SUMMARY 8 STATS$SGASTAT 8 STATS$LATCH_PARENT 10 STATS$SYSTEM_EVENT 19 STATS$ROLLSTAT 37 STATS$LATCH50 STATS$SYSSTAT 51 TABLE Size in MB -- -- STATS$PARAMETER56 STATS$LATCH_MISSES_SUMMARY 84 STATS$SQLTEXT 122 STATS$FILESTATXS 234 STATS$SQL_SUMMARY 886 STATS$LATCH_CHILDREN 2872 ( These are just tables , didnt show indexes here) Thank You , Madhu Reddy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Deleting Statspack tables.
Reddy - You didn't mention your Oracle version. I am on 8.1.6 and I don't think those scripts are available there (sorry, busy day, no time to research). So I just delete from stats$snapshot. It seems to remove data from the associated tables just fine. First I select the snap_id and snap_time from stats$snapshot to determine which snapshots to remove. It runs slowly (because of all the child tables?), so I just remove a hundred or so at a time. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 10, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Hello All, We have a job ( shell Script ) which deletes from the statspack tables every Sunday, but uses SPPURGE.sql ( $ORACLE_HOME/rdbms/admin). Seems like it is not deleting all tables and hence causing the tablespace to grow. Does anybody has a different approach which deletes all table without any referential integrity issues ?? I do not want to use SPTRUNC.sql please. Pl find below some of the statspack tables are growing so big ( also Indexes /PKs ). STATS$BG_EVENT_SUMMARY 7 STATS$ROWCACHE_SUMMARY 8 STATS$SGASTAT 8 STATS$LATCH_PARENT 10 STATS$SYSTEM_EVENT 19 STATS$ROLLSTAT 37 STATS$LATCH50 STATS$SYSSTAT 51 TABLE Size in MB -- -- STATS$PARAMETER56 STATS$LATCH_MISSES_SUMMARY 84 STATS$SQLTEXT 122 STATS$FILESTATXS 234 STATS$SQL_SUMMARY 886 STATS$LATCH_CHILDREN 2872 ( These are just tables , didnt show indexes here) Thank You , Madhu Reddy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Deleting Statspack tables.
Version : 8.1.7.3. I am not sure how it is working for you just by deleting from stats$snapshot and we do not have 8.1.6 here. Thanks -Original Message- Sent: Tuesday, June 10, 2003 4:40 PM To: Multiple recipients of list ORACLE-L Reddy - You didn't mention your Oracle version. I am on 8.1.6 and I don't think those scripts are available there (sorry, busy day, no time to research). So I just delete from stats$snapshot. It seems to remove data from the associated tables just fine. First I select the snap_id and snap_time from stats$snapshot to determine which snapshots to remove. It runs slowly (because of all the child tables?), so I just remove a hundred or so at a time. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 10, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Hello All, We have a job ( shell Script ) which deletes from the statspack tables every Sunday, but uses SPPURGE.sql ( $ORACLE_HOME/rdbms/admin). Seems like it is not deleting all tables and hence causing the tablespace to grow. Does anybody has a different approach which deletes all table without any referential integrity issues ?? I do not want to use SPTRUNC.sql please. Pl find below some of the statspack tables are growing so big ( also Indexes /PKs ). STATS$BG_EVENT_SUMMARY 7 STATS$ROWCACHE_SUMMARY 8 STATS$SGASTAT 8 STATS$LATCH_PARENT 10 STATS$SYSTEM_EVENT 19 STATS$ROLLSTAT 37 STATS$LATCH50 STATS$SYSSTAT 51 TABLE Size in MB -- -- STATS$PARAMETER56 STATS$LATCH_MISSES_SUMMARY 84 STATS$SQLTEXT 122 STATS$FILESTATXS 234 STATS$SQL_SUMMARY 886 STATS$LATCH_CHILDREN 2872 ( These are just tables , didnt show indexes here) Thank You , Madhu Reddy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Deleting Statspack tables.
Um, if I understand correctly, you're just trying to keep the volume down in your statspack tables. I use Tim Gorman's sppurpkg.sql package (on several different versions across several different operating systems). (www.evdbt.com) I have it set up to keep 14 days of data, but you can change that. It schedules the dbms_job for you. I just set up his job when I configure statspack on a new database, and then I never need to think about it again. You might take a look and see if it'll work for you. Barb --- Reddy, Madhusudana [EMAIL PROTECTED] wrote: Hello All, We have a job ( shell Script ) which deletes from the statspack tables every Sunday, but uses SPPURGE.sql ( $ORACLE_HOME/rdbms/admin). Seems like it is not deleting all tables and hence causing the tablespace to grow. Does anybody has a different approach which deletes all table without any referential integrity issues ?? I do not want to use SPTRUNC.sql please. Pl find below some of the statspack tables are growing so big ( also Indexes /PKs ). STATS$BG_EVENT_SUMMARY 7 STATS$ROWCACHE_SUMMARY 8 STATS$SGASTAT 8 STATS$LATCH_PARENT 10 STATS$SYSTEM_EVENT 19 STATS$ROLLSTAT 37 STATS$LATCH50 STATS$SYSSTAT 51 TABLE Size in MB -- -- STATS$PARAMETER56 STATS$LATCH_MISSES_SUMMARY 84 STATS$SQLTEXT 122 STATS$FILESTATXS 234 STATS$SQL_SUMMARY 886 STATS$LATCH_CHILDREN 2872 ( These are just tables , didnt show indexes here) Thank You , Madhu Reddy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: statspack snapshots cause 3-4 sec of 100% CPU utilization
Nice one, John! And quite portable. Runs on Solaris and Linux alike. On HP-UX 11.0 I had to modify it slightly, but it looks good too: if [ $# -eq 1 ] ;then UNIX95= ps -eo pid,pcpu,ruser,time,etime,args | grep $1 | sort -nr +1 | awk '{if (NR = 20) print substr($0,1,80)}' else same as above wo/ grep fi I usually used BSD stile of ps on Linux. Something like: ps aufx | egrep '(USER|oracle)' with exporting COLUMNS=200 prior to running this and stiking the puppy into an alias. But sorting by %CPU looks cool. (Solaris doesn't seem to understand the f flag and it should be /usr/ucb/ps, not default /usr/bin/ps) Ok, back to the original issue :-) Since snapshot causes 100% CPU util only for some 3 sec it was quite a challenge to catch it. The best I got so far is 72% for the shadow process taking the snapshot (after some 20 tries). I should probably put it in an infinite loop and spool (or tee) it to a file. Might as well try to catch /proc/pid/status (as I don't have the luxury of pmap here on Linux) for some memory stuff. One thing, John. Since it doesn't split CPU utilization into user and kernel buckets - how does this help me? Wouldn't it be nice to get output similar to ptime [or at least time(x)] in ps output? I am thinking of taking Dennis's advice and see what happens with level=0 or simply start commenting out code in the package and see when high CPU utilization drops (and I was hopping to go with level=7 to get some segement stats - he-he) Thanks, John. Cheers, Boris Dali. --- John Kanagaraj [EMAIL PROTECTED] wrote: Boris, Nice to discuss this with someone who understands the numerous (and various) options of 'sar' :) I use 'sar -r' to cross verify the 'rate of need for swap' - a sudden increase may mean either bursts of I/O (eating up File buffer space), memory leaks or a sudden rush of programs Could you take a quick snapshot of the top 20 CPU consumers using the script below when the snapshot runs? It takes the SID as a parameter to grep out only Oracle processes for that SID. The interesting part is that the CPUTIME *and* ELAPSED time is shown - you should run the snapshot as a script (as in sqlplus perfstat/ @snapshot.sql) where snapshot.sql has an execute, followed by an exit. This way, one has a crude set of CPU and Elapsed time for that process as it runs... I use this to quickly point out processes that are heavy and consistent CPU consumers, allowing me to rap some knuckles ;-) #!/bin/ksh # # Name: top20.ksh # Purpose: Display the top 20 CPU consumers. Specify a SID to collect # only those top procs related to that SID in a multi-db system # Author:John Kanagaraj, DBSoft Inc/ Aug 2001 # Notes: Tested and works on Solaris - may need adjustment for other OS # uptime echo PID %CPURUSER CPUTIME ELAPSED COMMAND if [ $# == 1 ]; then ps -eo pid,pcpu,ruser,time,etime,args | grep $1 | sort -nr +1 | head -20 | awk '{print substr($0,1,80)}' else ps -eo pid,pcpu,ruser,time,etime,args | sort -nr +1 | head -20 | awk '{print substr($0,1,80)}' fi John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Great, uplifting music - http://www.klove.com ** The opinions and statements above are entirely my own and not those of my employer or clients ** __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: statspack snapshots cause 3-4 sec of 100% CPU utilization
Mogens, Dennis, I know I am going to catch flames for this, but here goes: It seems to be quite fashionable to bash statspack, but help me out in understanding the alternatives to the StatsPack in the following cases: Case1: - At the client I am currently with, they have some 50+ applications. Performance is generally not an issue. Can things be optimized? Oh yeah. No doubt about it. Users don't complain though and 3-person DBA team focuses on operational/prod. support stuff. 3 weeks ago applcation support person took one of the applications offline and submitted a job to rebuild the indexes (this functionality is built into the app). DBA team wasn't obviously consulted as to whether or not it's of any benefit. In fact DBA team wasn't even aware that there's a maintenance activity going on :-( Job dutifully dropped the indexes (as it doesn't seem to be aware of rebuilding, not to mention rebuilding online etc), but got stuck somewhere on re-creating them... so next morning app support person realized that there's a problem and recalled that there is a DBA team that probably messed up his DB (from his response to the ticket). For DBA it didn't take long to see that what used to be a quick index lookup returning a single row, turned out to be a FTS on a 3mln row table as index wasn't re-created there. But... If OS and StatsPack monitoring was in place DBA would know that long before app support person showed up as iostat -nmxzP on Solaris (or even iostat -d -x on Linux) with StatsPack data (or something as simple as query comparing current v$filestat with baseline one) would be self evident that things changed. Utility to check execution plans against the baseline ones would be probably useful in this case, but I haven't heard about it before this thread :-) Case2: -- Application benchmarking. Last summer while with another client, DBA team was asked to monitor the newly purchased system in stress testing/sizing exercise. While not explicitely stated two additional objectves were to verify the scalability of the app with respect to the number of concurrent users as well as the data volumes. Mercury tools were used in colloboration with the StatsPack on the back-end. We couldn't get more than some 120 concurrent users and StatsPack clearly indicated the load profile w/ ~500,000 LIOs/sec, only ~50 KB/sec redo generation, 300:1 read:write ratio, with latch free being by far the most prominent wait event. This case is probably an extreme, but when the support engineers of the product received our Mercury/StatsPack report there was no doubt that SQL needs to be revisited The point I am trying to make is that I think there's monitoring for the sake of tuning (and than I agree - system wide data shouldn't probably drive the tuning effort). But there's also other types of monitoring where StatsPack seems to be quite useful to me. It all depends on the objectives. Cheers, Boris Dali. --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: Couldn't agree more. We need to stop using StatsPack for gathering lots and lots of stats we can't use for anything anyway. When two experts can look at the same summary data and get to different conclusions you're not gathering data at the correct level. It's sort of like the economists that will study the reams of data about GDP, GDI, money supply 1 thru 6, and what have you - and arrive at complete opposite conclusions. Same with bstat/estat, StatsPack, our own MirMon, etc. Mogens DENNIS WILLIAMS wrote: Boris - I'm not surprised in your results __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: any intro statspack docs online?
I know it is late but: Since nobody mention it - upload the report to http://www.oraperf.com/ and you will get a report with explanation and recommendations. Yechiel AdarMehish - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, May 22, 2003 5:41 PM Subject: any intro statspack docs online? Ive read the otn stuff and the niemic articles from Oracle mag.anything else? any articles that give a brief intro that includes installation? Id prefer not to dig into the Burleson book. Im really looking for something brief.Not too familiar with tuning wait events, but I 'think' we have some contention problems, and before I create an elaborate routine, Id like to get some metrics. any quick start guide? Licensing is based on customers honesty basically. The versions you can download are fully functional with all the options. Visit our web site at http://www.quantsystems.nl/ -Original Message-From: Joe Joe [mailto:[EMAIL PROTECTED] Sent: Thursday, May 22, 2003 11:37 AMTo: Multiple recipients of list ORACLE-LSubject: oracle trialware - features ?? Folks, Does "Oracle Enterprise Edition - Trialware" have all the features as that of alicensedone ? Is RMAN fully functional on a trial version of 9iR2 ? What makes the difference between these two ? If there is no difference, how does ORACLE prevent people from using it for PRODUCTION ? Read an interesting article about oracle licensing at http://www.vnunet.com/Analysis/1113993 and just thought of sharing it with u guys. Share your comments Gurus. Cheers, Joe. Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!Login To Lycos Mail
Re: statspack snapshots cause 3-4 sec of 100% CPU utilization
Good points, Boris. Thanks for that. If all users are doing the same things, then I guess system-wide data could indicate what's wrong for the average user. You can also use system-wide data to see if something changes overall on the system, then try to dig deeper - but only if you are very experienced and have stared at 100's of Statspack collection outputs and your system is behaving in some constant, predictable manner. Mogens Boris Dali wrote: Mogens, Dennis, I know I am going to catch flames for this, but here goes: It seems to be quite fashionable to bash statspack, but help me out in understanding the alternatives to the StatsPack in the following cases: Case1: - At the client I am currently with, they have some 50+ applications. Performance is generally not an issue. Can things be optimized? Oh yeah. No doubt about it. Users don't complain though and 3-person DBA team focuses on operational/prod. support stuff. 3 weeks ago applcation support person took one of the applications "offline" and submitted a job to rebuild the indexes (this functionality is built into the app). DBA team wasn't obviously consulted as to whether or not it's of any benefit. In fact DBA team wasn't even aware that there's a maintenance activity going on :-( Job dutifully dropped the indexes (as it doesn't seem to be aware of rebuilding, not to mention rebuilding online etc), but got stuck somewhere on re-creating them... so next morning app support person realized that there's a problem and recalled that there is a DBA team "that probably messed up his DB" (from his response to the ticket). For DBA it didn't take long to see that what used to be a quick index lookup returning a single row, turned out to be a FTS on a 3mln row table as index wasn't re-created there. But... If OS and StatsPack monitoring was in place DBA would know that long before app support person showed up as iostat -nmxzP on Solaris (or even iostat -d -x on Linux) with StatsPack data (or something as simple as query comparing current v$filestat with baseline one) would be self evident that things changed. Utility to check execution plans against the baseline ones would be probably useful in this case, but I haven't heard about it before this thread :-) Case2: -- Application benchmarking. Last summer while with another client, DBA team was asked to monitor the newly purchased system in stress testing/sizing exercise. While not explicitely stated two additional objectves were to verify the scalability of the app with respect to the number of concurrent users as well as the data volumes. Mercury tools were used in colloboration with the StatsPack on the back-end. We couldn't get more than some 120 concurrent users and StatsPack clearly indicated the load profile w/ ~500,000 LIOs/sec, only ~50 KB/sec redo generation, 300:1 read:write ratio, with latch free being by far the most prominent wait event. This case is probably an extreme, but when the support engineers of the product received our Mercury/StatsPack report there was no doubt that "SQL needs to be revisited" The point I am trying to make is that I think there's monitoring for the sake of tuning (and than I agree - system wide data shouldn't probably drive the tuning effort). But there's also other types of monitoring where StatsPack seems to be quite useful to me. It all depends on the objectives. Cheers, Boris Dali. --- Mogens_Nrgaard [EMAIL PROTECTED] wrote: Couldn't agree more. We need to stop using StatsPack for gathering lots and lots of stats we can't use for anything anyway. When two experts can look at the same summary data and get to different conclusions you're not gathering data at the correct level. It's sort of like the economists that will study the reams of data about GDP, GDI, money supply 1 thru 6, and what have you - and arrive at complete opposite conclusions. Same with bstat/estat, StatsPack, our own MirMon, etc. Mogens DENNIS WILLIAMS wrote: Boris - I'm not surprised in your results __ Post your free ad now! http://personals.yahoo.ca
Re: statspack snapshots cause 3-4 sec of 100% CPU utilization
What you need is detailed information over time. Start with SQL statements, into sessions, into the instance level. The problem is that this means that tons of data will be collected. So one has to be clever and reduce the amount of data collected. If you have data over time (SQL, session, instance), one can do some base lining and exceptions can be alerted on. If during monitoring a problem is detected one should have enough data to go back and analyze the problem without having to run the problem program again. And all of this has to be done with very little overhead. Performance problems can be repeatable or not repeatable (or at least difficult to predict when they will happen), you need to be able to fix both. SQL and Session data is probably the most valuable performance data, but collecting them can be expensive (more expensive in the case that you don't know when the performance problem will happen). How ever these problem(s) have been fixed and addressed by companies like Precise, Quest and BMC (probably others). They offer SQL statement and session information that can be folded into instance information. Anjo. Mogens Nørgaard wrote: Good points, Boris. Thanks for that. If all users are doing the same things, then I guess system-wide data could indicate what's wrong for the average user. You can also use system-wide data to see if something changes overall on the system, then try to dig deeper - but only if you are very experienced and have stared at 100's of Statspack collection outputs and your system is behaving in some constant, predictable manner. Mogens Boris Dali wrote: Mogens, Dennis, I know I am going to catch flames for this, but here goes: It seems to be quite fashionable to bash statspack, but help me out in understanding the alternatives to the StatsPack in the following cases: Case1: - At the client I am currently with, they have some 50+ applications. Performance is generally not an issue. Can things be optimized? Oh yeah. No doubt about it. Users don't complain though and 3-person DBA team focuses on operational/prod. support stuff. 3 weeks ago applcation support person took one of the applications offline and submitted a job to rebuild the indexes (this functionality is built into the app). DBA team wasn't obviously consulted as to whether or not it's of any benefit. In fact DBA team wasn't even aware that there's a maintenance activity going on :-( Job dutifully dropped the indexes (as it doesn't seem to be aware of rebuilding, not to mention rebuilding online etc), but got stuck somewhere on re-creating them... so next morning app support person realized that there's a problem and recalled that there is a DBA team that probably messed up his DB (from his response to the ticket). For DBA it didn't take long to see that what used to be a quick index lookup returning a single row, turned out to be a FTS on a 3mln row table as index wasn't re-created there. But... If OS and StatsPack monitoring was in place DBA would know that long before app support person showed up as iostat -nmxzP on Solaris (or even iostat -d -x on Linux) with StatsPack data (or something as simple as query comparing current v$filestat with baseline one) would be self evident that things changed. Utility to check execution plans against the baseline ones would be probably useful in this case, but I haven't heard about it before this thread :-) Case2: -- Application benchmarking. Last summer while with another client, DBA team was asked to monitor the newly purchased system in stress testing/sizing exercise. While not explicitely stated two additional objectves were to verify the scalability of the app with respect to the number of concurrent users as well as the data volumes. Mercury tools were used in colloboration with the StatsPack on the back-end. We couldn't get more than some 120 concurrent users and StatsPack clearly indicated the load profile w/ ~500,000 LIOs/sec, only ~50 KB/sec redo generation, 300:1 read:write ratio, with latch free being by far the most prominent wait event. This case is probably an extreme, but when the support engineers of the product received our Mercury/StatsPack report there was no doubt that SQL needs to be revisited The point I am trying to make is that I think there's monitoring for the sake of tuning (and than I agree - system wide data shouldn't probably drive the tuning effort). But there's also other types of monitoring where StatsPack seems to be quite useful to me. It all depends on the objectives. Cheers, Boris Dali. --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: Couldn't agree more. We need to stop using StatsPack for gathering lots and lots of stats we can't use for anything anyway. When two experts can look at the same summary data and get to different
statspack snapshots cause 3-4 sec of 100% CPU utilization
As subject line indicates standard (level 5) snapshots make vmstat 1 or sar -u 1 100 show 100% CPU utilization (75% system mode) for about 3 seconds. Is this normal? Is statspack that brutal on CPU? And why would that be a system mode primarily? Environment: Oracle 9.2.0.2 on Mandrake 9.0 (2.4.19-16mdkenterprise) 2.4GHz uniprocessor P4 box, 1GB SDRAM TIA, Boris Dali. __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: statspack snapshots cause 3-4 sec of 100% CPU utilization
Boris - I'm not surprised in your results. I wouldn't describe STATSPACK as brutal, but it is a significant hit, so you wouldn't want to start doing snaps at 1 second intervals. STATSPACK does collect a LOT of data, and you can adjust the amount of data collected with the level if you feel the need to reduce the brutality. If you find you only need a few pieces of information, you could write your own routines to collect just what you need. I have no idea why your system mode sees an impact. Perhaps someone who has more systems experience can venture a guess. You might try several measurements just in case you caught the system at a bad moment. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 05, 2003 4:05 PM To: Multiple recipients of list ORACLE-L As subject line indicates standard (level 5) snapshots make vmstat 1 or sar -u 1 100 show 100% CPU utilization (75% system mode) for about 3 seconds. Is this normal? Is statspack that brutal on CPU? And why would that be a system mode primarily? Environment: Oracle 9.2.0.2 on Mandrake 9.0 (2.4.19-16mdkenterprise) 2.4GHz uniprocessor P4 box, 1GB SDRAM TIA, Boris Dali. __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: statspack snapshots cause 3-4 sec of 100% CPU utilization
Boris, The default statspack snapshot is at level 5, which collects Top SQL (by buffer and Phys reads, etc.) from the Shared pool, and that would cause significant latching for a large shared pool which in turn results in a high CPU usage. You could try a level 0 snapshot and look at the CPU utilization at that time... John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Disappointment is inevitable, but Discouragement is optional! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Boris Dali [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 2:05 PM To: Multiple recipients of list ORACLE-L Subject: statspack snapshots cause 3-4 sec of 100% CPU utilization As subject line indicates standard (level 5) snapshots make vmstat 1 or sar -u 1 100 show 100% CPU utilization (75% system mode) for about 3 seconds. Is this normal? Is statspack that brutal on CPU? And why would that be a system mode primarily? Environment: Oracle 9.2.0.2 on Mandrake 9.0 (2.4.19-16mdkenterprise) 2.4GHz uniprocessor P4 box, 1GB SDRAM TIA, Boris Dali. __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: statspack snapshots cause 3-4 sec of 100% CPU utilization
Thanks, Dennis. I've been using statspack for quite some time now, but I've never bothered to ask myself an obvious question, namely what overhead does statspack impose on the system (taking about Heisenberg's principle of uncertainty, he-he) I guess part of the reason is the fact that statspack.snap returns prompt almost immediately so I sort of subconsciously assumed that it's ... light in terms of resource consumption. Thanks for the suggestion to write my own routines, but I don't think I'll go down this route. It's true that it's probably not too difficult as the statspack schema is pretty much self explanatory with RI constarints in place and besides (supprisingly) statspack package is not wrapped, but ... With every new release/feature you'll need to keep pace, which doesn't sound like fun to me. With standard out-of-the-box statspack you get it for free (stuff like segment stats in 9i statspack) Thanks again, Boris Dali. --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Boris - I'm not surprised in your results. I wouldn't describe STATSPACK as brutal, but it is a significant hit, so you wouldn't want to start doing snaps at 1 second intervals. STATSPACK does collect a LOT of data, and you can adjust the amount of data collected with the level if you feel the need to reduce the brutality. If you find you only need a few pieces of information, you could write your own routines to collect just what you need. I have no idea why your system mode sees an impact. Perhaps someone who has more systems experience can venture a guess. You might try several measurements just in case you caught the system at a bad moment. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 05, 2003 4:05 PM To: Multiple recipients of list ORACLE-L As subject line indicates standard (level 5) snapshots make vmstat 1 or sar -u 1 100 show 100% CPU utilization (75% system mode) for about 3 seconds. Is this normal? Is statspack that brutal on CPU? And why would that be a system mode primarily? Environment: Oracle 9.2.0.2 on Mandrake 9.0 (2.4.19-16mdkenterprise) 2.4GHz uniprocessor P4 box, 1GB SDRAM TIA, Boris Dali. __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: statspack snapshots cause 3-4 sec of 100% CPU utilization
Thanks, John. Any insight as to why is it primarily the system mode CPU? I've seen high system mode CPU utilization in non-Oracle stuff (like NFS), but for Oracle I thought it should be primarily user mode? Does Oracle's CPU used by this session represents user-, kernel-mode or both? And what about c in the raw traces? Thanks John, Boris Dali. --- John Kanagaraj [EMAIL PROTECTED] wrote: Boris, The default statspack snapshot is at level 5, which collects Top SQL (by buffer and Phys reads, etc.) from the Shared pool, and that would cause significant latching for a large shared pool which in turn results in a high CPU usage. You could try a level 0 snapshot and look at the CPU utilization at that time... John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Disappointment is inevitable, but Discouragement is optional! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Boris Dali [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 2:05 PM To: Multiple recipients of list ORACLE-L Subject: statspack snapshots cause 3-4 sec of 100% CPU utilization As subject line indicates standard (level 5) snapshots make vmstat 1 or sar -u 1 100 show 100% CPU utilization (75% system mode) for about 3 seconds. Is this normal? Is statspack that brutal on CPU? And why would that be a system mode primarily? Environment: Oracle 9.2.0.2 on Mandrake 9.0 (2.4.19-16mdkenterprise) 2.4GHz uniprocessor P4 box, 1GB SDRAM TIA, Boris Dali. __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: statspack snapshots cause 3-4 sec of 100% CPU utilization
Boris - I think John has an excellent point (as always). I just remembered that one vendor (can't recall which) has some sort of stealth method to directly sample the SQL buffer. They make a big deal about how it doesn't impact your system, so I would infer as John says that with a large shared pool this might be significant. My point is to just collect the information that is of value to you. If a level 0 gets you everything you need, go with that. When I suggest writing your own routines, I'm not proposing that you could collect all the information STATSPACK collects more efficiently, but if you only use one or two pieces of information and you need a level 5 snapshot to get it, then you might consider a quick script to collect just what you need. Also if you need frequent snapshots to capture certain critical data, you can avoid some snapshots. CPU cycles are meant to be used, so if snapshots aren't affecting your overall system, then what is the problem? Well, unfortunately you would like to collect statistics when the system is the busiest. I find STATSPACK to be the most useful when the system appears hung. With the GUI tools you are still clicking screens when the problem clears itself up. You can take a couple of STATSPACK snapshots and do damage control on the people side in between. But man are those snapshots SLW when the system is about belly up. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 06, 2003 9:20 AM To: Multiple recipients of list ORACLE-L Thanks, Dennis. I've been using statspack for quite some time now, but I've never bothered to ask myself an obvious question, namely what overhead does statspack impose on the system (taking about Heisenberg's principle of uncertainty, he-he) I guess part of the reason is the fact that statspack.snap returns prompt almost immediately so I sort of subconsciously assumed that it's ... light in terms of resource consumption. Thanks for the suggestion to write my own routines, but I don't think I'll go down this route. It's true that it's probably not too difficult as the statspack schema is pretty much self explanatory with RI constarints in place and besides (supprisingly) statspack package is not wrapped, but ... With every new release/feature you'll need to keep pace, which doesn't sound like fun to me. With standard out-of-the-box statspack you get it for free (stuff like segment stats in 9i statspack) Thanks again, Boris Dali. --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Boris - I'm not surprised in your results. I wouldn't describe STATSPACK as brutal, but it is a significant hit, so you wouldn't want to start doing snaps at 1 second intervals. STATSPACK does collect a LOT of data, and you can adjust the amount of data collected with the level if you feel the need to reduce the brutality. If you find you only need a few pieces of information, you could write your own routines to collect just what you need. I have no idea why your system mode sees an impact. Perhaps someone who has more systems experience can venture a guess. You might try several measurements just in case you caught the system at a bad moment. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 05, 2003 4:05 PM To: Multiple recipients of list ORACLE-L As subject line indicates standard (level 5) snapshots make vmstat 1 or sar -u 1 100 show 100% CPU utilization (75% system mode) for about 3 seconds. Is this normal? Is statspack that brutal on CPU? And why would that be a system mode primarily? Environment: Oracle 9.2.0.2 on Mandrake 9.0 (2.4.19-16mdkenterprise) 2.4GHz uniprocessor P4 box, 1GB SDRAM TIA, Boris Dali. __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from
RE: statspack snapshots cause 3-4 sec of 100% CPU utilization
Thanks, Dennis. I am with you on your point about GUI tools... --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Boris - I think John has an excellent point (as always). I just remembered that one vendor (can't recall which) has some sort of stealth method to directly sample the SQL buffer. They make a big deal about how it doesn't impact your system, so I would infer as John says that with a large shared pool this might be significant. My point is to just collect the information that is of value to you. If a level 0 gets you everything you need, go with that. When I suggest writing your own routines, I'm not proposing that you could collect all the information STATSPACK collects more efficiently, but if you only use one or two pieces of information and you need a level 5 snapshot to get it, then you might consider a quick script to collect just what you need. Also if you need frequent snapshots to capture certain critical data, you can avoid some snapshots. CPU cycles are meant to be used, so if snapshots aren't affecting your overall system, then what is the problem? Well, unfortunately you would like to collect statistics when the system is the busiest. I find STATSPACK to be the most useful when the system appears hung. With the GUI tools you are still clicking screens when the problem clears itself up. You can take a couple of STATSPACK snapshots and do damage control on the people side in between. But man are those snapshots SLW when the system is about belly up. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: statspack snapshots cause 3-4 sec of 100% CPU utilization
Thanks, John. No there's no paging/swapping going on (1GB real memory for a single 200MB SGA and just a couple of users). Out of curiousity, John. I usually measure paging via vmstat (si/so columns on Linux and pi/po everywhere else - everywhere else being HP-UX, Solaris and AIX), as well as via sar -w (swpin/s, swpot/s) on HP-UX/Solaris and sar -W on Linux (pswpin/s, pswpot/s). Is sar -r a better way? Quick check shows that on Linux it seems to report memory and swap utilization (but not in terms of rates, rather absolute numbers). On HP-UX it doesn't seem to be covered by man pages, but effectively the output is the same as -w. On Solaris it shows unused memory pages and disk blocks. And I don't currently have any IBM boxes around As for the wrong bucket... well, I'll be able to verify it in the next couple of weeks on Solaris and for sure on HP-UX. One thing I know is that both vmstat and sar -u agree here on Mandrake that it is the kernel-mode that chews up most of the CPU for this 3-4 sec snapshot time. Thanks, Boris Dali. --- John Kanagaraj [EMAIL PROTECTED] wrote: Boris, I missed the second part of your question... apologies. If your SGA/Shared pool was partly swapped out, I would assume that you might see an increased 'system' utilization. Did you check 'sar -q' and 'sar -r' at the same time to check? I haven't used mandrake - just wondering if the CPU cycles used for memory access are being counted against the wrong pigeonhole.. 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 ** __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: statspack snapshots cause 3-4 sec of 100% CPU utilization
Boris, Nice to discuss this with someone who understands the numerous (and various) options of 'sar' :) I use 'sar -r' to cross verify the 'rate of need for swap' - a sudden increase may mean either bursts of I/O (eating up File buffer space), memory leaks or a sudden rush of programs Could you take a quick snapshot of the top 20 CPU consumers using the script below when the snapshot runs? It takes the SID as a parameter to grep out only Oracle processes for that SID. The interesting part is that the CPUTIME *and* ELAPSED time is shown - you should run the snapshot as a script (as in sqlplus perfstat/ @snapshot.sql) where snapshot.sql has an execute, followed by an exit. This way, one has a crude set of CPU and Elapsed time for that process as it runs... I use this to quickly point out processes that are heavy and consistent CPU consumers, allowing me to rap some knuckles ;-) #!/bin/ksh # # Name: top20.ksh # Purpose: Display the top 20 CPU consumers. Specify a SID to collect # only those top procs related to that SID in a multi-db system # Author:John Kanagaraj, DBSoft Inc/ Aug 2001 # Notes: Tested and works on Solaris - may need adjustment for other OS # uptime echo PID %CPURUSER CPUTIME ELAPSED COMMAND if [ $# == 1 ]; then ps -eo pid,pcpu,ruser,time,etime,args | grep $1 | sort -nr +1 | head -20 | awk '{print substr($0,1,80)}' else ps -eo pid,pcpu,ruser,time,etime,args | sort -nr +1 | head -20 | awk '{print substr($0,1,80)}' fi John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Great, uplifting music - http://www.klove.com ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Boris Dali [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Subject: RE: statspack snapshots cause 3-4 sec of 100% CPU utilization Thanks, John. No there's no paging/swapping going on (1GB real memory for a single 200MB SGA and just a couple of users). Out of curiousity, John. I usually measure paging via vmstat (si/so columns on Linux and pi/po everywhere else - everywhere else being HP-UX, Solaris and AIX), as well as via sar -w (swpin/s, swpot/s) on HP-UX/Solaris and sar -W on Linux (pswpin/s, pswpot/s). Is sar -r a better way? Quick check shows that on Linux it seems to report memory and swap utilization (but not in terms of rates, rather absolute numbers). On HP-UX it doesn't seem to be covered by man pages, but effectively the output is the same as -w. On Solaris it shows unused memory pages and disk blocks. And I don't currently have any IBM boxes around As for the wrong bucket... well, I'll be able to verify it in the next couple of weeks on Solaris and for sure on HP-UX. One thing I know is that both vmstat and sar -u agree here on Mandrake that it is the kernel-mode that chews up most of the CPU for this 3-4 sec snapshot time. Thanks, Boris Dali. --- John Kanagaraj [EMAIL PROTECTED] wrote: Boris, I missed the second part of your question... apologies. If your SGA/Shared pool was partly swapped out, I would assume that you might see an increased 'system' utilization. Did you check 'sar -q' and 'sar -r' at the same time to check? I haven't used mandrake - just wondering if the CPU cycles used for memory access are being counted against the wrong pigeonhole.. 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 ** __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: statspack snapshots cause 3-4 sec of 100% CPU utilization
Couldn't agree more. We need to stop using StatsPack for gathering lots and lots of stats we can't use for anything anyway. When two experts can look at the same summary data and get to different conclusions you're not gathering data at the correct level. It's sort of like the economists that will study the reams of data about GDP, GDI, money supply 1 thru 6, and what have you - and arrive at complete opposite conclusions. Same with bstat/estat, StatsPack, our own MirMon, etc. Mogens DENNIS WILLIAMS wrote: Boris - I'm not surprised in your results. I wouldn't describe STATSPACK as brutal, but it is a significant hit, so you wouldn't want to start doing snaps at 1 second intervals. STATSPACK does collect a LOT of data, and you can adjust the amount of data collected with the level if you feel the need to reduce the brutality. If you find you only need a few pieces of information, you could write your own routines to collect just what you need. I have no idea why your system mode sees an impact. Perhaps someone who has more systems experience can venture a guess. You might try several measurements just in case you caught the system at a bad moment. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 05, 2003 4:05 PM To: Multiple recipients of list ORACLE-L As subject line indicates standard (level 5) snapshots make vmstat 1 or sar -u 1 100 show 100% CPU utilization (75% system mode) for about 3 seconds. Is this normal? Is statspack that brutal on CPU? And why would that be a system mode primarily? Environment: Oracle 9.2.0.2 on Mandrake 9.0 (2.4.19-16mdkenterprise) 2.4GHz uniprocessor P4 box, 1GB SDRAM TIA, Boris Dali. __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: statspack snapshots cause 3-4 sec of 100% CPU utilization
Boris, I missed the second part of your question... apologies. If your SGA/Shared pool was partly swapped out, I would assume that you might see an increased 'system' utilization. Did you check 'sar -q' and 'sar -r' at the same time to check? I haven't used mandrake - just wondering if the CPU cycles used for memory access are being counted against the wrong pigeonhole.. 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: Boris Dali [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 7:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: statspack snapshots cause 3-4 sec of 100% CPU utilization Thanks, John. Any insight as to why is it primarily the system mode CPU? I've seen high system mode CPU utilization in non-Oracle stuff (like NFS), but for Oracle I thought it should be primarily user mode? Does Oracle's CPU used by this session represents user-, kernel-mode or both? And what about c in the raw traces? Thanks John, Boris Dali. --- John Kanagaraj [EMAIL PROTECTED] wrote: Boris, The default statspack snapshot is at level 5, which collects Top SQL (by buffer and Phys reads, etc.) from the Shared pool, and that would cause significant latching for a large shared pool which in turn results in a high CPU usage. You could try a level 0 snapshot and look at the CPU utilization at that time... John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Disappointment is inevitable, but Discouragement is optional! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Boris Dali [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2003 2:05 PM To: Multiple recipients of list ORACLE-L Subject: statspack snapshots cause 3-4 sec of 100% CPU utilization As subject line indicates standard (level 5) snapshots make vmstat 1 or sar -u 1 100 show 100% CPU utilization (75% system mode) for about 3 seconds. Is this normal? Is statspack that brutal on CPU? And why would that be a system mode primarily? Environment: Oracle 9.2.0.2 on Mandrake 9.0 (2.4.19-16mdkenterprise) 2.4GHz uniprocessor P4 box, 1GB SDRAM TIA, Boris Dali. __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
RE: Statspack recomendations.
The bookpool is no doubt the best and clean site for tech books with low SH charges. For price comparison http://www.bestwebbuys.com/books/ is a good site... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 14 Mar 2003 14:23:55 -0800 I alwasys use bookfinder.com to search for books; it queries quite a few sites and generally finds the best price for me (new and/or used). Another useful site is the ISBN locator at www.isbn.nu Good luck! Rich -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Metelsky Sent: Thursday, January 23, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Statspack recomendations. Go to bookpool.com. Best prices on tech books. I've ordered several books from them and have always been happy. Yes definetly... But this one Conducting the Oracle Job Interview Is not available at bookpool or amazon... (personally I like the buy used books from amazon) quite a few deals there Ive always been reasonably pleased with the service as well. Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Rich Holland INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Statspack recomendations.
I alwasys use bookfinder.com to search for books; it queries quite a few sites and generally finds the best price for me (new and/or used). Another useful site is the ISBN locator at www.isbn.nu Good luck! Rich -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Metelsky Sent: Thursday, January 23, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Statspack recomendations. Go to bookpool.com. Best prices on tech books. I've ordered several books from them and have always been happy. Yes definetly... But this one Conducting the Oracle Job Interview Is not available at bookpool or amazon... (personally I like the buy used books from amazon) quite a few deals there Ive always been reasonably pleased with the service as well. Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Rich Holland INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Concat SQL_TEXT from Statspack tables.
H. It seems that I don't get replies to a lot of my posts. Do I ask the hard questions or just stupid ones? On sencond thought, don't answer that... ;) In any case, in reinventing the wheel, I decided to just create a function that uses a REF CURSOR to generically concat the column for me: CREATE OR REPLACE FUNCTION newwheel (p_tabname IN VARCHAR2, p_colname IN VARCHAR2, p_whereclause IN VARCHAR2) RETURN VARCHAR2 AS TYPE rc_type IS REF CURSOR; rc rc_type; v_col VARCHAR2(2000); v_resultVARCHAR2(4000); BEGIN OPEN rc FOR 'SELECT '||p_colname||' FROM '||p_tabname||' '||p_whereclause; LOOP FETCH rc INTO v_col; EXIT WHEN rc%NOTFOUND; v_result := v_result||v_col; END LOOP; CLOSE rc; RETURN(v_result); END newwheel; Then I can: SELECT newwheel('PERFSTAT.STATS$SQLTEXT','sql_text','WHERE HASH_VALUE = 1232131312') FROM dual; Hope this can help someone else! Rich Well I'm sorry, but I'm going to have to shoot you. Right-oh, sir. THUMP What a senseless waste of human life. -- Monty Python -Original Message- Sent: Monday, February 10, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Hey all, In 8.1.7.4, does anyone have a SQL that will take the output from the following: SELECT sql_text FROM PERFSTAT.STATS$SQLTEXT SS WHERE SS.HASH_VALUE = :myhash ORDER BY PIECE ...and append/concat all the rows into a single column. I *know* someone's done this before and I don't want to re-invent the wheel unless I have to. TIA! Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Concat SQL_TEXT from Statspack tables.
Hey all, In 8.1.7.4, does anyone have a SQL that will take the output from the following: SELECT sql_text FROM PERFSTAT.STATS$SQLTEXT SS WHERE SS.HASH_VALUE = :myhash ORDER BY PIECE ...and append/concat all the rows into a single column. I *know* someone's done this before and I don't want to re-invent the wheel unless I have to. TIA! Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: STATSPACK
Thanks! I have the 8.1.7 scripts, do I have to install them in the 8.0.6.3 databases? Ruth - Original Message - From: DENNIS WILLIAMS To: Multiple recipients of list ORACLE-L Sent: Wednesday, January 29, 2003 2:49 PM Subject: RE: STATSPACK Ruth - I think you can, but you must run the 8.1.7 scripts there. Do youhave the 3 Oracle magazine articles that introduced STATSPACK? I think thiswas mentioned there.Dennis WilliamsDBA, 40%OCPLifetouch, Inc.[EMAIL PROTECTED] -Original Message-Sent: Wednesday, January 29, 2003 12:54 PMTo: Multiple recipients of list ORACLE-LHello everyone,I hope this is a quick question. Can you run 8.1.7 Statspack on an 8.0.6.3instance?Thanks in advance,Ruth-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ruth Gramolini INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: STATSPACK
Thanks Scott! That's just what I need. Ruth - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, January 29, 2003 5:19 PM Subject: RE: STATSPACK See:http://www.oracle.com/oramag/oracle/00-Mar/index.html?statspack-other.htmland related articles.Scott ShaferSan Antonio, TX210.581.6217 -Original Message- From: Stephen Andert [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 3:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: STATSPACK Ruth, I've heard people talk about "downgrading" the statspack scripts to earlier versions, but I've never done it. Try searching "downgrade STATSPACK" on Metalink and OTN for starters. Good luck Stephen [EMAIL PROTECTED] 01/29/03 12:59PM I believe that an 8.1.7 statspack can run on an Oracle8 or higher database. Dave -Original Message- Sent: Wednesday, January 29, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Hello everyone, I hope this is a quick question. Can you run 8.1.7 Statspack on an 8.0.6.3 instance? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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.net-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: STATSPACK
On Wednesday 29 January 2003 16:38, Viktor wrote: Jared, You've got all the knowledge, for real! Is there a possibility of I wish. performance decrease when running statspack in Oracle 8.0.5? Thanks, I'm running level 0 snapshots every 15 minutes on 8.0.4 with no noticeable impact. Jared Viktor [EMAIL PROTECTED] wrote:No, but you can run the 8.1.6 version. There's a couple of special scripts for doing so. http://www.oracle.com/oramag/oracle/00-Mar/index.html?statspack-other.html Jared Ruth Gramolini Sent by: [EMAIL PROTECTED] 01/29/2003 10:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L cc: Hello everyone, I hope this is a quick question. Can you run 8.1.7 Statspack on an 8.0.6.3 instance? Thanks in advance, Ruth Content-Type: text/html; charset=us-ascii; name=Attachment: 1 Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
STATSPACK
Hello everyone, I hope this is a quick question. Can you run 8.1.7 Statspack on an 8.0.6.3 instance? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: STATSPACK
I believe that an 8.1.7 statspack can run on an Oracle8 or higher database. Dave -Original Message- Sent: Wednesday, January 29, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Hello everyone, I hope this is a quick question. Can you run 8.1.7 Statspack on an 8.0.6.3 instance? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).