| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: CPU Problem
Definately worth repeating. Its an excellent article. Read it last night.
Hmmm. Maybe I need a life.
Do they even make records anymore? Would the children of today even understand the reference? I suddenly feel very old. :-)
>From: "Cary Millsap" <cary.millsap_at_hotsos.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: CPU Problem
>Date: Thu, 07 Nov 2002 14:43:46 -0800
>
>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: hamid.alavi_at_quovadx.com
>
>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: ListGuru_at_fatcity.com (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: cary.millsap_at_hotsos.com
>
>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: ListGuru_at_fatcity.com (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: David Davis INET: davisdav_at_hotmail.com 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: ListGuru_at_fatcity.com (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).Received on Fri Nov 08 2002 - 10:49:51 CST
 |
 |