Re: CPU time contention

VIVEK_SHARMA wrote:
>
> We are Doing an OLTP Transaction Benchmark & getting the following contention "CPU time "
> on HP Super Dome machines with XP1024 Storage
>
> How may this be addressed ?
>
> Any Best Practice Kernel parameters that may be set for HP Server ?
>
> Thanks
>
> Snap Id Snap Time Sessions Curs/Sess Comment
> ------- ------------------ -------- --------- -------------------
> Begin Snap: 265 26-Apr-03 04:44:27 1,276 18.6
>
> End Snap: 266 26-Apr-03 04:59:33 1,276 18.7
>
> Elapsed: 15.10 (mins)
>
> Top 5 Timed Events
> ~~~~~~~~~~~~~~~~~~ % Total
> Event Waits Time (s) Ela Time
> -------------------------------------------- ------------ ----------- --------
> CPU time 1,175 79.07
> log file sync 132,814 166 11.17
> log file parallel write 129,139 101 6.82
> latch free 751 32 2.16
> rdbms ipc reply 203 10 .68
> -------------------------------------------------------------
>
> P.S. will provide any details needed
>

Vivek,

   OS parameters are one thing, reducing CPU usage another. Logical I/Os, latching and hashing, among others, are Oracle processes known to be heavy on CPU. Sometimes a bit more physical I/O helps ...

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.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).