Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> After install: default performance guidelines
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