Re: Maxing CPU

Wayne,

I think you are not looking at the problem areas and completely concentrating on the CPU's and Memory. My colleagues and I have worked extensively with tuning systems like yours. In most cases the problem was with the optimizer and the code running against the database. Fixing this is very easy if you are willing to add some indexes, hints etc. ( Not a very clean way but that helps a lot )

Here are a list of things I would look at.

1. Optimizer Mode : Peoplesoft App runs best in RBO and Reports run best in CBO and the solution is to find a middle ground.
2. Reports : Who coded these reports and did the developers ever tune them. From my experience you should not even max 2 cpu's in a 4 cpu system with 10 users running their processes.

Let me know if you need more help

Uday Bikkasani
Tactics Inc.
ubikkasani_at_tacticsus.com

Wayne S. March <wmarch_at_worldnet.att.net> wrote in message news: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 Fri Nov 27 1998 - 16:49:26 CST