Our Server configuration is as follows: Dual PIII 700 Xeon Processor, 1 GB RAM, 3*18 GB SCSI Hard Disks.
We plan to use Win2k as our OS. The Server will work primarily as a database server (8.1.7) but would also function as a file-server.
There are about 50 oracle users, with about 30-40 using concurrently our application developed in Developer 2k (shortly to be upgraded to 6i).
I need to know the optimum parameter values in the init.ora file for these:
open_cursors, db_block_buffers, db_block_size, shared_pool_size, large_pool_size, processes, sort_area_size and any other relevant parameters.
I am also wondering if we can use the PARALLEL option since we have 2 CPUs?
What are the tradeoffs for using archived-redo-logs, and will it be useful for our scenario?
My intention is to learn as much as I can without causing performance lags. So any and all help/advice will be appreciated.