no apology necessary... sometimes it takes repetition before it sinks in. At least you try. :)
--- Cary Millsap <[EMAIL PROTECTED]> wrote: > 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). __________________________________________________ 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).
