The Best Performance

From: Jener R. Silva <jener_at_erols.com>
Date: Mon, 27 Apr 1998 09:52:12 -0400
Message-ID: <6i22eu$a54@news.dot.gov>

Given the following machine config:

Quad Pentium PRO 200 Mhz
256 MB RAM
Windows NT 4.0
Oracle 8
Adaptec AHA-3940UW SCSI

Drive C: 2 GB
Drive D: 4 GB
Drive E: 4 GB
Drive F: 4 GB
Drive G: 9 GB
Drive H: 9 GB
Drive I: 9 GB

What would be the best installation approach? I have a large amount of data to store; mostly DSS system no OLTP transactions.
Should I increase the RAM?
Should I create SYSTEM tablespace on drive C: and use the other ones for DATA, INDEXES, TEMP, and ROLLBACK? Received on Mon Apr 27 1998 - 08:52:12 CDT