no apology necessary... sometimes it takes repetition before it sinks
in.
At least you try. :)
- Cary Millsap <cary.millsap_at_hotsos.com> 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: 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).
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: wisernet100_at_yahoo.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 Thu Nov 07 2002 - 18:03:36 CST
