Re: Maxing CPU

From: Nisar Tareen <ntareen_at_attcanada.net>
Date: Sat, 19 Dec 1998 08:13:24 -0500
Message-ID: <7dXe2.207$gm5.41@tundra.ops.attcanada.net>

Wayne,

I had just working on the same issue one my site, with HP K460 and 2gig of memory.

I had disscuss with HP and the issue is not in the cpu utilization, the best senario will be 80% by users and 20% by system.

At 100% utilization, check if queues are building on processess , disk or swap then you have problem else nothing to worry about.

Regards.

Nisar Tareen.
Allianz Canada.
ntareen_at_allianz.ca

Wayne S. March wrote in message <73n1hs$5uc_at_bgtnsc02.worldnet.att.net>...
>To All,
>
>I am running ORACLE and PeopleSoft on NT on a 4 200 Mghz Pentium Pro box
>with one gig of memory.
>I just tuned the box to have
>shared_pool_size = 104000000
>db_block_buffers = 20000
>db_file_multiblock_read_count = 16
>log_buffer = 534000
>db_block_size = 2048
>sql_sort_area = 2000000
>
>Now when 10 or so users run reports I sometimes notice that Oracle is
>running all
>four cpus at 100%..Any Ideas
>
>Wayne
>
>
>
Received on Sat Dec 19 1998 - 07:13:24 CST