Hi all,
I'm trying to put together a computer that will run Oracle (spatial) and ArcGIS. I'm under the impression that hard drive performance is important for Oracle and will benefit overall performance. The minimum system requirements aren't much help. I will be working on files that are 10's of MB in size and sometimes a few hundredd MB. I already have a monitor, and I don't think the video card is important. The other program is ArcGIS and it has some interesting limitations....
- Does not run on 64bit OS
- Does not use more the one core.
So my plan is to focus on a fast dual-core cpu, 4GB of ram, and some fast hard drives.
CPU: Intel E8500
RAM: 4GB Generic DDR2 667
Hard Drives:
1. 73GB 15k RPM SAS drive for OS and programs
2. 300GB 15k RPM SAS drive for data
3. 300GB 15k RPM SAS drive for data
Video Card: 256MB generic workstation card with dual dvi output
Sound Card: Onboard
Is it worth it to go up to quad-core for Oracle? I don't know exactly what I'll be doing with Oracle since I've never used it before! I could drop the SAS drives and go with a 10k SATA boot drive and a 1TB storage drive so that I could fit a fast quad-core in the budget.
Second, I think 600GB of storage might be cutting it close. If I need more storage I will have to switch to SATA. Is it worth doing a Raid Array to get some of the speed back? I'm guessing I would use the software RAID that comes with the motherboard. I can do any RAID and have access to a server for backups, but can't decide what combination would be best. I was thinking either 3-4 large (320GB or 500GB) disks in a raid 5 with everything on it, or doing a 160 10k RPM SATA disk for the OS and programs and then 2-3 large disks in AID 0.
This is for work and there will be NO overclocking. I know, I know
I'm trying to put together a computer that will run Oracle (spatial) and ArcGIS. I'm under the impression that hard drive performance is important for Oracle and will benefit overall performance. The minimum system requirements aren't much help. I will be working on files that are 10's of MB in size and sometimes a few hundredd MB. I already have a monitor, and I don't think the video card is important. The other program is ArcGIS and it has some interesting limitations....
- Does not run on 64bit OS
- Does not use more the one core.
So my plan is to focus on a fast dual-core cpu, 4GB of ram, and some fast hard drives.
CPU: Intel E8500
RAM: 4GB Generic DDR2 667
Hard Drives:
1. 73GB 15k RPM SAS drive for OS and programs
2. 300GB 15k RPM SAS drive for data
3. 300GB 15k RPM SAS drive for data
Video Card: 256MB generic workstation card with dual dvi output
Sound Card: Onboard
Is it worth it to go up to quad-core for Oracle? I don't know exactly what I'll be doing with Oracle since I've never used it before! I could drop the SAS drives and go with a 10k SATA boot drive and a 1TB storage drive so that I could fit a fast quad-core in the budget.
Second, I think 600GB of storage might be cutting it close. If I need more storage I will have to switch to SATA. Is it worth doing a Raid Array to get some of the speed back? I'm guessing I would use the software RAID that comes with the motherboard. I can do any RAID and have access to a server for backups, but can't decide what combination would be best. I was thinking either 3-4 large (320GB or 500GB) disks in a raid 5 with everything on it, or doing a 160 10k RPM SATA disk for the OS and programs and then 2-3 large disks in AID 0.
This is for work and there will be NO overclocking. I know, I know