we're gonna need a group hug soon :) truly, I would rather have Cary and Anjo and Tim repeat and repeat and repeat themselves (so what they say finally sinks into my brain) than have them off this list.
And please, I don't mean to offend anyone by leaving them out! --- Tim Gorman <[EMAIL PROTECTED]> wrote: > That's OK. The world is a better place since you do... > > ---- > > By the way, how many folks have watched "Prime Minister's Questions" > in the > British House of Commons? In the US, it sometimes shows on C-SPAN or > C-SPAN2, late at night. I swear, it is more entertaining and funnier > than > 90% of the other stuff shown on the ol' glass teat, especially when a > row > develops... > > Anyway, as you might guess, the British Prime Minister (Maggie > Thatcher was > my favorite -- the quality of star players has declined since) would > be > asked questions and he/she answers them -- simple. Usually, current > events > would drive the questions, so the PM would usually respond to a > question > once and then, as more and more MPs stand up and repeat the same > question -- > the PM would simply respond, "I refer my honorable colleague to the > comments > I made some moments ago". Over and over and over again; like a > formula. > Saves time, wear, and tear... > > Just say: "I refer my [ learned | esteemed | honorable ] colleague > to the > comments I made several threads ago"... > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, November 07, 2002 3:43 PM > > > > SQL that does excessively many reads from memory. Trace it. Read > "Why > > you should focus on LIOs instead of PIOs" at > www.hotsos.com/catalog. > > > > My apologies to the list for repeating myself like a broken record. > :) > > > > > > Cary Millsap > > Hotsos Enterprises, Ltd. > > http://www.hotsos.com > > > > Upcoming events: > > - Hotsos Clinic, Dec 9-11 Honolulu > > - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 > Dallas > > - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas > > > > > > -----Original Message----- > > Alavi > > Sent: Thursday, November 07, 2002 3:04 PM > > To: Multiple recipients of list ORACLE-L > > > > Hi List, > > > > We are facing with some CPU problem (cpu 100% usage!), Just want to > get > > some > > idea from you guys, any clue what can cause this problem: > > Here is a copy of some part of ora.ini > > This happen during usage of some long query with subquery, this can > be > > the > > cause of problem or just some wrong setting in ini file. > > I appreciate your help. > > > > compatible = 8.1.7.4 > > db_block_buffers = 10000 > > db_block_lru_latches = 4 > > db_block_size = 8192 > > db_file_multiblock_read_count = 16 > > hash_area_size = 2048000 > > java_pool_size = 20971520 > > large_pool_size = 614400 > > log_buffer = 262144 > > log_checkpoint_interval = 10000 > > log_checkpoint_timeout = 1800 > > max_enabled_roles = 30 > > open_cursors = 300 > > optimizer_index_caching = 90 > > optimizer_index_cost_adj = 35 > > os_authent_prefix = "" > > processes = 100 > > session_cached_cursors = 100 > > shared_pool_size = 134217728 > > sort_area_retained_size = 262144 > > sort_area_size = 262144 > > timed_statistics = TRUE > > > > > > > > > > > > Hamid Alavi > > Office 818 737-0526 > > Cell 818 416-5095 > > > > > > > > > > > > > > ======================= Confidentiality Statement > > ======================= > > The information contained in this message and any attachments is > > intended only for the use of the individual or entity to which it > is > > addressed, and may contain information that is PRIVILEGED, > CONFIDENTIAL > > and exempt from disclosure under applicable law. If you have > received > > this message in error, you are prohibited from copying, > distributing, or > > > > using the information. Please contact the sender immediately by > return > > e-mail and delete the original message from your system. > > ===================== End Confidentiality Statement > > ===================== > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Hamid Alavi > > 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.com > > -- > > 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). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > 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). __________________________________________________ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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).
