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).