Re: Maxing CPU

I have to chime in with my two cents here.

100 % utilization may or may not be a bad thing. This means that the reports are getting as much CPU time as possible. On the other hand, if the other users are still getting acceptable response times there is no problem.

Problems do happen when a process takes over the CPU and doesn't release it for anything. This is usually a sign of a poorly written query.

Regards,

Nigel

In article <7dXe2.207$gm5.41_at_tundra.ops.attcanada.net>,   "Nisar Tareen" <ntareen_at_attcanada.net> wrote:
> 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
> >
> >
> >
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 21 1998 - 14:49:50 CST