Need suggestions for filesystem config, spindle separation, striping for HP-UX/PeopleSoft

We are installing a new server. Anyone have any opinions on the best database server filesystem configuration to provide best performance for the PeopleSoft HRMS application?

Platform: HP 9000 Series L-1000
1 x 440MHz PA8500 CPU
1024MB RAM
2 x 36GB disk (72GB total)
HP-UX 11.0 64-bit O/S
Oracle 8.1.7 DBMS
Apache Web Server and PeopleSoft8 A/S to run on this same box

Question: What is the best disk spindle separation scheme for the following oracle object types: data tables, indexes, rollbacks, redo logs, system tables, temp tables, oracle software files

Question: I always used to see that Oracle recommended placing data tables and their indexes on separate spindles. However, in the 8.0 performance tuning manuals they say that this is not necessary since the index is read first, then the table afterward and therefore there is no disk contention issue. If so, wouldn't this have always been the case, or is this something new from 8.0 onward?

Question: Do you recommend disk striping? What stripe size best suits the PeopleSoft HRMS application?

Question: As an example, on a system with only two large capacity spindles (providing limited capability to separate objects by spindle), would the best choice be to stripe everything on both spindles?

Question: Should anything not be striped (e.g. system tables, rollbacks, oracle software files, etc.)?

Thanks for any tips!
John K. Hayes
AikoSys, Inc.
aikosys_at_earthlink.net Received on Tue Feb 13 2001 - 15:50:51 CST