Re: CPU Problem

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" <ORACLE-L_at_fatcity.com> 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: 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: Tim Gorman
  INET: Tim_at_SageLogix.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).