RE: CPU Pegged at 100%

From: Mohammed Shakir <mshakir08816_at_yahoo.com>
Date: Sat, 27 Apr 2002 19:58:19 -0800
Message-ID: <F001.004516B4.20020427195819@fatcity.com>

Raghu

I am also chasing a ghost like yours. Even though I have much larger number of cache Buffer chain waits, I look at the total picture. Looking at my statspack report, I noticed that application spends 30% of the time in buffer cache contention. How about the other 70%?

Looking at the buffer gets reports, I found each of my processes having 2.2 Billion buffer gets. Looking at my application, I should not have more than 250Million buffer gets for each process. Off course the problem is with the SQL. So I am working first on my SQL and then if buffer cache chains problem still exist, I will work on it.

So check the buffer gets and find out SQL that are doing it and work on them.

Shakir

---

Mohammed Shakir
CompuSoft, Inc.
11 Heather Way
East Brunswick, NJ 08816-2825
(732) 672-0464 (Cell)
(732) 257-6001 (Home)

---

Do You Yahoo!?
Yahoo! Health - your guide to health and wellness http://health.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammed Shakir
  INET: mshakir08816_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Sat Apr 27 2002 - 22:58:19 CDT