Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Maxing CPU

Maxing CPU

From: Wayne S. March <wmarch_at_worldnet.att.net>
Date: 27 Nov 1998 20:20:12 GMT
Message-ID: <73n1hs$5uc@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 - 14:20:12 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US