04-14-08, 06:28 #1Registered User
- Join Date
- Apr 2008
Unanswered: Server Configuration for 10gR2 Database (PROD)
We are in the process of purchasing a server for migrating our database from 9iR1 (Pentium 3) to a latest server (with 10gR2).
Please could you assist me in getting the answers to the following questions pertaining to the server configuration for Oracle 10gR2 Database:
1. We have an option of purchasing an IBM Blade Server to host the Database and use SAN Storage for the Database file storage. Please could you let me know if this would be a right combination for an OLTP Database?
2. Is having Database files on SAN Storage a good idea? Please elaborate in terms of performance benefits, risks involved, availability factors.
3. Keeping in mind that we are still using a Pentium-3 Dual Core Server (1.5 GB RAM, 50 GB HDD) for app. 150 sessions on 1 production instance (1 GB SGA and 40 GB DB files), it would be highly appreciated if you could also suggest a rough configuration for the new database server that will host a 10gr2 production DB(migrated from 9ir1)?
Thanks & Regards
04-14-08, 13:08 #2Registered User
- Join Date
- Jun 2003
- West Palm Beach, FL
2) YES. Among other good stuff, if server crashes/breaks, just connect the SAN to another server.
3) I would go for Quad processor, 8 GB RAM, 2-4 GB SGA, 160 GB SAN storage for db files (sys, flash recovery, data, etc,... and backup) plus whatever you need for apps. (this is pure rough speculation)
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb