Re: Tuning Question and Advice needed ..
Thank you Sergey .. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, April 27, 2002 6:28 AM Hello Bunyamin, 1) These values are values between starting utlbstat and utlestat (not from database startup). 2) It's impossible to make all wait events=0. Importance of different events depends on what database you have (OLTP, DSS, mixed). Optimims for wait events are zero wait time :-) You should query another views for identifying are these values optimal. For example for Latch Free event you should do the following query: select name, sleeps/gets from v$latch where name='cache buffers lru chain'; sleeps/gets should be 99% or you have to increase DB_BLOCK_LRU_LATCHES (default value for this parameter should be num_cpu*1.5 maximum value not greater then num_cpu*6) So for another events. Your values are normal for approx 10 Gb database with hundred or more concurrent sessions (working hard). Saturday, April 27, 2002, 2:18:32 AM, you wrote: BKK Dear Gurus , I need your help .. BKK I run UTLBSTAT and then after 2 hour run the UTLESTAT.sql scripts as internal and look at the report.txt generated ... BKK On report.txt , I see that BKK System wide wait events for background processes: BKK System wide wait events for non-background processes : BKK Latch statistics BKK Statistics on no_wait gets of latches BKK Sum IO operations over tablespaces BKK and other things also is in the report. BKK Question 1) BKK What I wonder is BKK Are these values between the start and end times of scripts. BKK What I mean is , for example Is the wait events for non-background processes list in report are the wait events occured between UTLBSTAT script run time T1 and UTLESTAT script run time T2 ? BKK or are they total wait events from the startup of database ? BKK Question 2) BKK I see lots of wait events occur .. BKK What will I give importance to ? BKK will I try to make 0 wait event in report. What are the optimums of wait events. ? BKK For example I see BKK Latch free event occured for 3015 times , BKK control file sequential read occured for 182 times , BKK log file sync occured for 1756 times BKK direct path read occured for 11000 times BKK direct path write occured for 6000 times BKK Are these values normal ? Will I try to make them 0 in the tomarrows report ? BKK How can I comment on the report ? Is there a link you can tell me to understand the problems and will help me to read and action about the problems ? BKK Thank you... BKK Bunyamin K. Karadeniz BKK Oracle DBA / Developer BKK Civilian IT Department BKK Havelsan A.S. Eskisehir yolu BKK 7.km Ankara Turkey BKK Phone: +90 312 2873565 / 1217 BKK Mobile : +90 535 3357729 -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Tuning Question and Advice needed ..
Dear Gurus , I need your help .. I run UTLBSTAT and then after 2 hour run the UTLESTAT.sql scripts as internal and look at the report.txt generated ... On report.txt , I see that System wide wait events for background processes: System wide wait events for non-background processes : Latch statistics Statistics on no_wait gets of latches Sum IO operations over tablespaces and other things also is in the report. Question 1) What I wonder is Are these values between the start and end times of scripts. What I mean is , for example Is the wait events for non-background processes list in report are the wait events occured between UTLBSTAT script run time T1 and UTLESTAT script run time T2 ? or are they total wait events from the startup of database ? Question 2) I see lots of wait events occur .. What will I give importance to ? will I try to make 0 wait event in report. What are the optimums of wait events. ? For example I see "Latch free event" occured for 3015 times , "control file sequential read" occured for 182 times , "log file sync" occured for 1756 times "direct path read" occured for 11000 times "direct path write" occured for 6000 times Are these values normal ? Will I try to make them 0 in the tomarrows report ? How can I comment on the report ? Is there a link you can tell me to understand the problems and will help me to read and action about the problems ? Thank you... Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729
RE: Tuning Question and Advice needed ..
Bunyamin - I went to http://www.google.com http://www.google.com and searched for utlbstat and received 1,050 results. I would recommend that you try the same and read up on the resources available over the Internet. I would also recommend the book Oracle Performance Tuning 101 by Gaja Krishna Vaidyanatha Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, April 26, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Dear Gurus , I need your help .. I run UTLBSTAT and then after 2 hour run the UTLESTAT.sql scripts as internal and look at the report.txt generated ... On report.txt , I see that System wide wait events for background processes: System wide wait events for non-background processes : Latch statistics Statistics on no_wait gets of latches Sum IO operations over tablespaces and other things also is in the report. Question 1) What I wonder is Are these values between the start and end times of scripts. What I mean is , for example Is the wait events for non-background processes list in report are the wait events occured between UTLBSTAT script run time T1 and UTLESTAT script run time T2 ? or are they total wait events from the startup of database ? Question 2) I see lots of wait events occur .. What will I give importance to ? will I try to make 0 wait event in report. What are the optimums of wait events. ? For example I see Latch free event occured for 3015 times , control file sequential read occured for 182 times , log file sync occured for 1756 times direct path read occured for 11000 times direct path write occured for 6000 times Are these values normal ? Will I try to make them 0 in the tomarrows report ? How can I comment on the report ? Is there a link you can tell me to understand the problems and will help me to read and action about the problems ? Thank you... Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tuning Question and Advice needed ..
Hello Bunyamin, 1) These values are values between starting utlbstat and utlestat (not from database startup). 2) It's impossible to make all wait events=0. Importance of different events depends on what database you have (OLTP, DSS, mixed). Optimims for wait events are zero wait time :-) You should query another views for identifying are these values optimal. For example for Latch Free event you should do the following query: select name, sleeps/gets from v$latch where name='cache buffers lru chain'; sleeps/gets should be 99% or you have to increase DB_BLOCK_LRU_LATCHES (default value for this parameter should be num_cpu*1.5 maximum value not greater then num_cpu*6) So for another events. Your values are normal for approx 10 Gb database with hundred or more concurrent sessions (working hard). Saturday, April 27, 2002, 2:18:32 AM, you wrote: BKK Dear Gurus , I need your help .. BKK I run UTLBSTAT and then after 2 hour run the UTLESTAT.sql scripts as internal and look at the report.txt generated ... BKK On report.txt , I see that BKK System wide wait events for background processes: BKK System wide wait events for non-background processes : BKK Latch statistics BKK Statistics on no_wait gets of latches BKK Sum IO operations over tablespaces BKK and other things also is in the report. BKK Question 1) BKK What I wonder is BKK Are these values between the start and end times of scripts. BKK What I mean is , for example Is the wait events for non-background processes list in report are the wait events occured between UTLBSTAT script run time T1 and UTLESTAT script run time T2 ? BKK or are they total wait events from the startup of database ? BKK Question 2) BKK I see lots of wait events occur .. BKK What will I give importance to ? BKK will I try to make 0 wait event in report. What are the optimums of wait events. ? BKK For example I see BKK Latch free event occured for 3015 times , BKK control file sequential read occured for 182 times , BKK log file sync occured for 1756 times BKK direct path read occured for 11000 times BKK direct path write occured for 6000 times BKK Are these values normal ? Will I try to make them 0 in the tomarrows report ? BKK How can I comment on the report ? Is there a link you can tell me to understand the problems and will help me to read and action about the problems ? BKK Thank you... BKK Bunyamin K. Karadeniz BKK Oracle DBA / Developer BKK Civilian IT Department BKK Havelsan A.S. Eskisehir yolu BKK 7.km Ankara Turkey BKK Phone: +90 312 2873565 / 1217 BKK Mobile : +90 535 3357729 -- Best regards, Sergeymailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sergey V Dolgov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).