Re: Maxing CPU

From: Ronald <ronr_at_wxs.nl>
Date: Sat, 28 Nov 1998 22:00:12 +0100
Message-ID: <01HW.B28622EC0004ED66020AECF0@news.wxs.nl>

On Fri, 27 Nov 1998 21:20:12 +0100, 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
>
>
>

Could be a lot of fulltable scan's going on. Most of the database will be in cache so IO is not a problem.
--
Ronald

---

mailto:ronr_at_wxs.nl
http://home.wxs.nl/~ronr/RonR.html (last update: june 8th, 1998) http://www.maccentral.com/news/9804/migration.shtml (forward migration home)

I think so I mac ! Received on Sat Nov 28 1998 - 15:00:12 CST