Re: After install: default performance guidelines

Your point about only two disks is well taken. The database is initially quite small - less than a GB. So for now thats all we have.

The inserts are being done by a client program using OCI. I heard they are using 'Bulk Insert' but thats about all I know about it.

What guidelines can you offer about the redo log group? How big, and how many?

In article <yuFX4.100$u35.60464_at_nnrp2.sbc.net>,   "spencer" <spencerp_at_swbell.net> wrote:
> 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.
> >
>
>

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