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 -> After install: default performance guidelines

After install: default performance guidelines

From: <orauser_at_my-deja.com>
Date: 2000/05/27
Message-ID: <8gn5cm$1rv$1@nnrp1.deja.com>#1/1

I installed Oracle on a 4 CPU NT box with 4 GB memory and two disks. Other than increasing the main memory pool and sort area size, I dont know if there are any other basic performance parameters to set?

I am inserting data into one large table, and I see that the system is only using about 5-10% of one CPU. The table is partitioned by hash across two tablespaces each of which have one data file and they are on different disks.

I know the system is nowhere from being totally utilized, is there anything I can do to use more system resources?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat May 27 2000 - 00:00:00 CDT

Original text of this message

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