Re: After install: default performance guidelines

two disks? 4 cpus aren't going to make the heads move quicker or make the disks spin any faster... i suspect your bottleneck is related to disk i/o...

which disks are used for the index(es)?
rollback segments ? redo logs?

you can verify that checkpoints aren't causing a performance problem. in addition to the size of the redo logs. there are two parameters in the init<sid>.ora file that affect the frequency of checkpoints.

if the database is in archive log mode, make sure that you have enough redo log groups that the archive process can keep up.

what program are you using to do the inserts? SQL*Loader can sometimes load rows faster, especially in "direct" mode.

two disks? you're kidding, right ?

<orauser_at_my-deja.com> wrote in message
news:8gn5cm$1rv$1_at_nnrp1.deja.com...
> 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 Fri May 26 2000 - 00:00:00 CDT