RE: quick suggestions for tuning ?
Prem Head for http://www.hotsos.com and study their documents. Cary Millsap, who is kind enough to participate on this list, has identified LIO as a key performance issue. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August 11, 2003 10:00 AM To: Multiple recipients of list ORACLE-L Thanks a lot Connor. Apart from bind vars.,LIO is a big issue here. 54 million consistent gets. does it mean that db_cache_size (700M) is small ? any good docs or links regarding LIO and how to deal with it ? Can u explain me Connor ? Regards, Jp. From: Connor McDonald [EMAIL PROTECTED] Subject: Fwd: Re: quick suggestions for tuning ? Date: 10-08-2003 23:44:25 Its not really rocket science here... CPU is at the top of the timed event - and what causes CPU (or is the most common cause) - logical I/O. 54 million consistent gets later down in the report probably a bit of a giveaway there :-) Next section in the report is some nice queries that use up 4 or so million buffer gets. Good ones to start with... As you've already noticed, no bind variables. Then some other miscellaneous things - look at how much free memory you have in most of your pools SGA breakdown difference - might be able to use that better elsewhere. cheers connor -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: quick suggestions for tuning ?
Yes, I agree. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 12 Aug 2003 22:19:23 -0800 quote You poor guy. Try to bring some guy with you who can speak English and Japanese to resolve ths communication problem. in 1993 when I was working in Tokyo for 10 days in my ex-employer office and having problem with Harware, the Japanese Engineer was brining one Bangadeshi guy to communicate with me in English and it worked just fine. /quote Rafiq,it doesn't work the same way everywhere yaar. Bringing a guy just for translation is nearly impossible here. i know some japanese and i try to manage with that. even if u know Japanese,it's not a cake walk to convince a japanese. Client's vary their attitude varies. Do u agree with me ?! Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: quick suggestions for tuning ?
Its not really rocket science here... CPU is at the top of the timed event - and what causes CPU (or is the most common cause) - logical I/O. 54 million consistent gets later down in the report probably a bit of a giveaway there :-) Next section in the report is some nice queries that use up 4 or so million buffer gets. Good ones to start with... As you've already noticed, no bind variables. Then some other miscellaneous things - look at how much free memory you have in most of your pools SGA breakdown difference - might be able to use that better elsewhere. cheers connor --- Prem Khanna J [EMAIL PROTECTED] wrote: Guys, I have attached statspack report here. The ENV is Oracle 9.2.0.3 / Win2k AS - SP3. 1.Can you tell me which INIT parameters are to be changed which will give improved performance ? 2.can someone give a rough idea about where the bottlenecks are ? I read the doc 228913.1 - Systemwide Tuning using STATSPACK Reports and gave a try with YAPP also. Bind vars are to be used - that is one i found out from statspack report. just new to statspack and so i'm seeking ur suggestions. Regards, Jp. ATTACHMENT part 2 application/octet-stream = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: Re: quick suggestions for tuning ?
Ah but then everything is fine ... Could we suggest buying a bigger machine :-) ? - --- Original Message --- - From: Jared Still [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Mon, 11 Aug 2003 07:44:23 But his BCHR is 99.57% ! On Sun, 2003-08-10 at 07:44, Connor McDonald wrote: Its not really rocket science here... CPU is at the top of the timed event - and what causes CPU (or is the most common cause) - logical I/O. 54 million consistent gets later down in the report probably a bit of a giveaway there :-) Next section in the report is some nice queries that use up 4 or so million buffer gets. Good ones to start with... As you've already noticed, no bind variables. Then some other miscellaneous things - look at how much free memory you have in most of your pools SGA breakdown difference - might be able to use that better elsewhere. cheers connor --- Prem Khanna J [EMAIL PROTECTED] wrote: Guys, I have attached statspack report here. The ENV is Oracle 9.2.0.3 / Win2k AS - SP3. 1.Can you tell me which INIT parameters are to be changed which will give improved performance ? 2.can someone give a rough idea about where the bottlenecks are ? I read the doc 228913.1 - Systemwide Tuning using STATSPACK Reports and gave a try with YAPP also. Bind vars are to be used - that is one i found out from statspack report. just new to statspack and so i'm seeking ur suggestions. Regards, Jp. ATTACHMENT part 2 application/octet-stream = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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). ___ _ --- -- --- -- Regards, Stephane Faroult Oriole -- 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: quick suggestions for tuning ?
Prem Khanna J wrote: Guys, I have attached statspack report here. The ENV is Oracle 9.2.0.3 / Win2k AS - SP3. 1.Can you tell me which INIT parameters are to be changed which will give improved performance ? 2.can someone give a rough idea about where the bottlenecks are ? I read the doc 228913.1 - Systemwide Tuning using STATSPACK Reports and gave a try with YAPP also. Bind vars are to be used - that is one i found out from statspack report. just new to statspack and so i'm seeking ur suggestions. Regards, Jp. Name: MOREI0808-2024.sql MOREI0808-2024.sqlType: unspecified type (application/octet-stream) Encoding: Base64 I think that indexing the 'profile' table on entpc and laccess could be a good thing to start with. Probably some work to do on MSG_HISTORY as well. You are right about bind variables, but it won't help the queries on MSG_HISTORY, where the long string of ORs is obviously dynamically built. Oracle doesn't often choose to iterate as it should with a long string of ORs (or a long IN list), the 'FIRST_ROWS' hint may help. You can also tell your developers to review the English irregular verbs, especially 'to send'. Forget about the magical INIT parameter. -- Regards, Stephane Faroult Oriole Software -- 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: quick suggestions for tuning ?
Ermmm you can have the rest of the message if you wish which is to say that indexes on Profile(sex,entpc,laccess) and profile(sex,entpc,faccess) Would appear to be called for. Obviousdly you will wish to analyze the schema, and even more obviously you will do all this in test first. If sex is a column that does not have many values (one would think no more than 8 or so) then you can make this a compressed index degree 1, if entpc also has very few values compressing it degree 2 might be helpful (though I'd be sceptical). Niall -Original Message- From: Niall Litchfield [mailto:[EMAIL PROTECTED] Sent: 12 August 2003 22:27 To: '[EMAIL PROTECTED]' Subject: RE: quick suggestions for tuning ? Probably normal. You are likely repeatedly, and excessively, reading the same blocks which are obviously cached after the first read. I have a theory - lets call it theory 42 that states that any system which has a BCHR of 99.5% is either trivial or performing abysmally due entirely to bad sql. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Prem Khanna J Sent: 12 August 2003 11:44 To: Multiple recipients of list ORACLE-L Subject: Re: quick suggestions for tuning ? Jared, LIO being high and BHCR ~ 99% : is this is a normal or abnormal ? Regards, Jp. 12-08-2003 00:44:23, Jared Still [EMAIL PROTECTED] wrote: But his BCHR is 99.57% ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: Niall Litchfield 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: quick suggestions for tuning ?
JP,
Since i'm working with a japanese client,communication is a huge
barrier and convincing them is a HERCULEAN task
You poor guy. Try to bring some guy with you who can speak English and
Japanese to resolve ths communication problem. in 1993 when I was working in
Tokyo for 10 days in my ex-employer office and having problem with Harware,
the Japanese Engineer was brining one Bangadeshi guy to communicate with me
in English and it worked just fine.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 12 Aug 2003 02:39:23 -0800
Thanx a lot Tanel.
select count(*) as cnt from profile where sex = ''j?«' and entpc
= '192.168.15.1' and laccess between to_date('2003/08/08 00:00:
00','/mm/dd hh24:mi:ss') and to_date('2003/08/08 23:59:59','
/mm/dd hh24:mi:ss')
Do you have index on laccess column for example?
Though there is index on laccess , it is not yet analyzed.
none of the tables/index are analyzed yet.
Sorry,i should have told this earlier.
Since i'm working with a japanese client,communication is a huge
barrier and convincing them is a HERCULEAN task :((
Let me do that first and get back to u.
Thanks and Regards,
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
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).
_
Tired of spam? Get advanced junk mail protection with MSN 8.
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: Re: quick suggestions for tuning ?
Jared, LIO being high and BHCR ~ 99% : is this is a normal or abnormal ? Regards, Jp. 12-08-2003 00:44:23, Jared Still [EMAIL PROTECTED] wrote: But his BCHR is 99.57% ! OK, let's have another try at it. Let's say that you are a travelling salesman, with a number of prospects to visit at a number of locations. Obviously, you may say take your list of prospects and visit them in say alphabetical order. No need to be very clever to guess that, if this is how you proceed, you are going to have a rather impressive mileage. If you have any common sense, you are going to try to see which prospect is close to which other one and, assuming no other constraint about the availability of the people you wan to meet, you are going to see your propects by geographical clusters. In the end, you will have seen the same people than as if you take the list alphabetically. But your mileage will be much, much less. Quite obviously you have to pour fuel in your car. Everytime you stop at a pump, you have delays, because of queues (many cars, not many fuel stations in this area), cashiers, when you have to pay, all seem incredibly lazy and more eager to serve coffee to other customers than let you pay, and you are quite irritated by this because each time you waste a _lot_ of time. Let's say that you take the stupid approach. One way to finish your circuit faster is to say 'hey, I have a *great* idea, I am going to borrow my brother-in-law's car which has a tank twice as big as my car and as efficient an engine. This way I shall spend twice less time on refuelling and it will be faster'. Of course it will. But not necessarily much. Obviously, you should try to minimise the mileage first - necessarily, you'll pay fewer visits to the pump and in fact, you may even not bothering using a car with a smaller tank if you have dramatically decreased the mileage. Logical I/Os are your mileage, and physical I/Os are the same as refuelling. Increasing the size of your SGA is taking a car with a bigger tank. And computing statistics is knowing the distance between the various locations you want to visit - enabling the optimiser to compute a suitable route. The BCHR is the number of miles you do per refuelling - says something about the quality of the engine but otherwise mostly irrelevant. Regards, Stephane Faroult Oriole -- 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: RE: quick suggestions for tuning ?
Profile(sex,entpc,laccess) and profile(sex,entpc,faccess) Would appear to be called for. Obviousdly you will wish to analyze the schema, and even more obviously you will do all this in test first. If sex is a column that does not have many values (one would think no more than 8 or so) then you can make this a compressed index degree 1, if entpc also has very few values compressing it degree 2 might be helpful (though I'd be sceptical). Thanx a lot for your suggestions Niall. i hope the indexes on sex entpc in profile table is not necessary. so there are some unwanted indexes to be dropped. On the contrary, the performance by index scan will decrease because Oracle must translate the prefix, suffix part in corresponding key Found the above lines in a metalink doc. about index compression. I don't know how far it will affect my performance.Need to test it. Thanks and Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: quick suggestions for tuning ?
Thanks, Dennis. Prem, in particular, please go to http://www.hotsos.com/catalog and download the document called Why you should focus on LIOs instead of PIOs. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Denver, Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- DENNIS WILLIAMS Sent: Monday, August 11, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Prem Head for http://www.hotsos.com and study their documents. Cary Millsap, who is kind enough to participate on this list, has identified LIO as a key performance issue. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August 11, 2003 10:00 AM To: Multiple recipients of list ORACLE-L Thanks a lot Connor. Apart from bind vars.,LIO is a big issue here. 54 million consistent gets. does it mean that db_cache_size (700M) is small ? any good docs or links regarding LIO and how to deal with it ? Can u explain me Connor ? Regards, Jp. From: Connor McDonald [EMAIL PROTECTED] Subject: Fwd: Re: quick suggestions for tuning ? Date: 10-08-2003 23:44:25 Its not really rocket science here... CPU is at the top of the timed event - and what causes CPU (or is the most common cause) - logical I/O. 54 million consistent gets later down in the report probably a bit of a giveaway there :-) Next section in the report is some nice queries that use up 4 or so million buffer gets. Good ones to start with... As you've already noticed, no bind variables. Then some other miscellaneous things - look at how much free memory you have in most of your pools SGA breakdown difference - might be able to use that better elsewhere. cheers connor -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: Cary Millsap 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: quick suggestions for tuning ?
With absolutely no disrespect to Cary, I'd recommend the original poster head to the Concepts guide before heading to hotsos. Gotta walk before you run and all that kind of stuff... Cheers Connor --- Cary Millsap [EMAIL PROTECTED] wrote: Thanks, Dennis. Prem, in particular, please go to http://www.hotsos.com/catalog and download the document called Why you should focus on LIOs instead of PIOs. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Denver, Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- DENNIS WILLIAMS Sent: Monday, August 11, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Prem Head for http://www.hotsos.com and study their documents. Cary Millsap, who is kind enough to participate on this list, has identified LIO as a key performance issue. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August 11, 2003 10:00 AM To: Multiple recipients of list ORACLE-L Thanks a lot Connor. Apart from bind vars.,LIO is a big issue here. 54 million consistent gets. does it mean that db_cache_size (700M) is small ? any good docs or links regarding LIO and how to deal with it ? Can u explain me Connor ? Regards, Jp. From: Connor McDonald [EMAIL PROTECTED] Subject: Fwd: Re: quick suggestions for tuning ? Date: 10-08-2003 23:44:25 Its not really rocket science here... CPU is at the top of the timed event - and what causes CPU (or is the most common cause) - logical I/O. 54 million consistent gets later down in the report probably a bit of a giveaway there :-) Next section in the report is some nice queries that use up 4 or so million buffer gets. Good ones to start with... As you've already noticed, no bind variables. Then some other miscellaneous things - look at how much free memory you have in most of your pools SGA breakdown difference - might be able to use that better elsewhere. cheers connor -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: Cary Millsap 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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
Re: quick suggestions for tuning ?
Thanx a lot Jared. With due respect to all my GURUS on this list, i start reading the docs AGAIN. Thanx and Regards, Jp. 13-08-2003 05:46:32, [EMAIL PROTECTED] wrote: From: [EMAIL PROTECTED] Date: Tue, 12 Aug 2003 13:46:32 -0700 I would say that is often the norm. I would not say that it is however desirable. What you need to do is ask yourself What is the benefit of re-reading the data in the buffer over and over? When a database has a high Buffer Hit Ratio it will also have a large number of LIO's, and the reason is poorly written SQL that reads the same data from the cache, over and over. There papers at hotsos.com that will explain this in detail. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: quick suggestions for tuning ?
Jared, LIO being high and BHCR ~ 99% : is this is a normal or abnormal ? Regards, Jp. 12-08-2003 00:44:23, Jared Still [EMAIL PROTECTED] wrote: But his BCHR is 99.57% ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: quick suggestions for tuning ?
quote You poor guy. Try to bring some guy with you who can speak English and Japanese to resolve ths communication problem. in 1993 when I was working in Tokyo for 10 days in my ex-employer office and having problem with Harware, the Japanese Engineer was brining one Bangadeshi guy to communicate with me in English and it worked just fine. /quote Rafiq,it doesn't work the same way everywhere yaar. Bringing a guy just for translation is nearly impossible here. i know some japanese and i try to manage with that. even if u know Japanese,it's not a cake walk to convince a japanese. Client's vary their attitude varies. Do u agree with me ?! Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: quick suggestions for tuning ?
Probably normal. You are likely repeatedly, and excessively, reading the same blocks which are obviously cached after the first read. I have a theory - lets call it theory 42 that states that any system which has a BCHR of 99.5% is either trivial or performing abysmally due entirely to bad sql. Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Prem Khanna J Sent: 12 August 2003 11:44 To: Multiple recipients of list ORACLE-L Subject: Re: quick suggestions for tuning ? Jared, LIO being high and BHCR ~ 99% : is this is a normal or abnormal ? Regards, Jp. 12-08-2003 00:44:23, Jared Still [EMAIL PROTECTED] wrote: But his BCHR is 99.57% ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: Niall Litchfield 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: quick suggestions for tuning ?
I would say that is often the norm. I would not say that it is however desirable. What you need to do is ask yourself What is the benefit of re-reading the data in the buffer over and over? When a database has a high Buffer Hit Ratio it will also have a large number of LIO's, and the reason is poorly written SQL that reads the same data from the cache, over and over. There papers at hotsos.com that will explain this in detail. Jared Prem Khanna J [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/12/2003 03:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: quick suggestions for tuning ? Jared, LIO being high and BHCR ~ 99% : is this is a normal or abnormal ? Regards, Jp. 12-08-2003 00:44:23, Jared Still [EMAIL PROTECTED] wrote: But his BCHR is 99.57% ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: quick suggestions for tuning ?
Thanx a lot Tanel.
select count(*) as cnt from profile where sex = ''j?«' and entpc
= '192.168.15.1' and laccess between to_date('2003/08/08 00:00:
00','/mm/dd hh24:mi:ss') and to_date('2003/08/08 23:59:59','
/mm/dd hh24:mi:ss')
Do you have index on laccess column for example?
Though there is index on laccess , it is not yet analyzed.
none of the tables/index are analyzed yet.
Sorry,i should have told this earlier.
Since i'm working with a japanese client,communication is a huge
barrier and convincing them is a HERCULEAN task :((
Let me do that first and get back to u.
Thanks and Regards,
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
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: quick suggestions for tuning ?
Depends on who do you ask, provided you don't ask Anjo or Cary. On 2003.08.12 06:44, Prem Khanna J wrote: Jared, LIO being high and BHCR 99% : is this is a normal or abnormal ? Regards, Jp. 12-08-2003 00:44:23, Jared Still [EMAIL PROTECTED] wrote: But his BCHR is 99.57% ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: quick suggestions for tuning ?
Hi!
Number of LIOs are mostly issue of Application, SQL statement and execution
plan tuning. Thus no buffers help reducing LIOs, they can only good for
reducion PIOs.
I think you should take the statements from largest number of LIOs in your
statspack report and tune them.
For example, after you've put bind variables to your code, check this
statement:
select count(*) as cnt from profile where sex = ''j«' and entpc
= '192.168.15.1' and laccess between to_date('2003/08/08 00:00:
00','/mm/dd hh24:mi:ss') and to_date('2003/08/08 23:59:59','
/mm/dd hh24:mi:ss')
Do an explain plan for this statement (set autot trace exp, then run the
query). Check the output, for example, are any indexes used for this query?
Do you have index on laccess column for example?
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 11, 2003 5:59 PM
Thanks a lot Connor.
Apart from bind vars.,LIO is a big issue here.
54 million consistent gets.
does it mean that db_cache_size (700M) is small ?
any good docs or links regarding LIO and how to deal with it ?
Can u explain me Connor ?
Regards,
Jp.
From: Connor McDonald [EMAIL PROTECTED]
Subject: Fwd: Re: quick suggestions for tuning ?
Date: 10-08-2003 23:44:25
Its not really rocket science here...
CPU is at the top of the timed event - and what causes
CPU (or is the most common cause) - logical I/O. 54
million consistent gets later down in the report
probably a bit of a giveaway there :-)
Next section in the report is some nice queries that
use up 4 or so million buffer gets. Good ones to
start with... As you've already noticed, no bind
variables.
Then some other miscellaneous things - look at how
much free memory you have in most of your pools SGA
breakdown difference - might be able to use that
better elsewhere.
cheers
connor
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
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: Tanel Poder
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: quick suggestions for tuning ?
Thanks a lot Stephane. There are indexes on profile table which u pointed out. but none of the tables/indexes are analyzed yet. Connor pointed that there are 54million consistent gets. LIO is high. does it mean that db_cache_size (700M) is small ? how to deal with this ? Can u throw some light on this Stephane ? Regards, Jp. From: Stephane Faroult [EMAIL PROTECTED] Subject: Fwd: Re: quick suggestions for tuning ? Date: 11-08-2003 00:29:23 I think that indexing the 'profile' table on entpc and laccess could be a good thing to start with. Probably some work to do on MSG_HISTORY as well. You are right about bind variables, but it won't help the queries on MSG_HISTORY, where the long string of ORs is obviously dynamically built. Oracle doesn't often choose to iterate as it should with a long string of ORs (or a long IN list), the 'FIRST_ROWS' hint may help. You can also tell your developers to review the English irregular verbs, especially 'to send'.Forget about the magical INIT parameter. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: quick suggestions for tuning ?
At 06:59 AM 8/11/2003 -0800, you wrote: Thanks a lot Connor. Apart from bind vars.,LIO is a big issue here. 54 million consistent gets. does it mean that db_cache_size (700M) is small ? No, the buffer pool size has absolutely nothing to do with the number of logical IOs. Its size only determines how many of the LIOs end up as PIOs - the infamous buffer hit ratio. The only way to reduce the # of LIOs is through SQL tuning. any good docs or links regarding LIO and how to deal with it ? Can u explain me Connor ? 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: Re: quick suggestions for tuning ?
Thanks a lot Stephane. There are indexes on profile table which u pointed out. but none of the tables/indexes are analyzed yet. First thing to do. Connor pointed that there are 54million consistent gets. LIO is high. does it mean that db_cache_size (700M) is small ? how to deal with this ? Can u throw some light on this Stephane ? db_cache_size has nothing to do with LIOs. LIOs are the number of blocks you need to visit to return an answer to your queries. Physical layout may influence it (by 'physical layout' I mean how dense the data is in your blocks, not where you put it on disk) but it mostly depend on what you are asking and how you are asking it, memory has nothing to do with it. If you haven't allocated enough memory, you will do more PIOs, but reduce LIOs in no way. Let's take a stupid analogy : say that LIOs are a big heap of sand you wish to move from one place to another. Having too small a SGA is like using a tea-spoon to do it. Obviously, using a shovel will be better. But you'll move as much sand in the end. To reduce LIOs you must optimize the code - make Oracle visit much fewer blocks, first of all, which may be achieved by a number of means. Indexes are obvious but quite often, for large volumes, full scans may be more efficient - try not to have any prejudice. Check what Oracle does (execution plans), try alternate ways to write the same query. SET AUTOTRACE ON TRACEONLY + SET TIMING ON are very useful under SQL*Plus. Once the size of your sand heap has dwindled to almost nothing, you may decide that perhaps a bigger spoon would work better, but this is the very last thing to contemplate. HTH, Stephane Faroult Oriole -- 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: RE: quick suggestions for tuning ?
Thanks a lot Millsap,Stephane Faroult,Jared Still,Wolfgang,Tanel and Dennis for your pointers and suggestions. I owe a lot to you Oracle Gurus. A novice DBA like me is ever grateful to this wonderful list. I love this list. Thanks once again. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: quick suggestions for tuning ?
But his BCHR is 99.57% ! On Sun, 2003-08-10 at 07:44, Connor McDonald wrote: Its not really rocket science here... CPU is at the top of the timed event - and what causes CPU (or is the most common cause) - logical I/O. 54 million consistent gets later down in the report probably a bit of a giveaway there :-) Next section in the report is some nice queries that use up 4 or so million buffer gets. Good ones to start with... As you've already noticed, no bind variables. Then some other miscellaneous things - look at how much free memory you have in most of your pools SGA breakdown difference - might be able to use that better elsewhere. cheers connor --- Prem Khanna J [EMAIL PROTECTED] wrote: Guys, I have attached statspack report here. The ENV is Oracle 9.2.0.3 / Win2k AS - SP3. 1.Can you tell me which INIT parameters are to be changed which will give improved performance ? 2.can someone give a rough idea about where the bottlenecks are ? I read the doc 228913.1 - Systemwide Tuning using STATSPACK Reports and gave a try with YAPP also. Bind vars are to be used - that is one i found out from statspack report. just new to statspack and so i'm seeking ur suggestions. Regards, Jp. ATTACHMENT part 2 application/octet-stream = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: quick suggestions for tuning ?
Thanks a lot Connor. Apart from bind vars.,LIO is a big issue here. 54 million consistent gets. does it mean that db_cache_size (700M) is small ? any good docs or links regarding LIO and how to deal with it ? Can u explain me Connor ? Regards, Jp. From: Connor McDonald [EMAIL PROTECTED] Subject: Fwd: Re: quick suggestions for tuning ? Date: 10-08-2003 23:44:25 Its not really rocket science here... CPU is at the top of the timed event - and what causes CPU (or is the most common cause) - logical I/O. 54 million consistent gets later down in the report probably a bit of a giveaway there :-) Next section in the report is some nice queries that use up 4 or so million buffer gets. Good ones to start with... As you've already noticed, no bind variables. Then some other miscellaneous things - look at how much free memory you have in most of your pools SGA breakdown difference - might be able to use that better elsewhere. cheers connor -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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).
