The main points you need to bear in mind are:
- Ensure that the server has enough memory and power to handle the transactions per second you plan to put through.
- Ensure that you use RAID 0+1 (stripped and mirror) as your storage option.
- Your database design will also play a crucial role in overall performance of your database.
Dig Deeper on Oracle database design and architecture
Related Q&A from Harish Harbham
SOA and Integration expert Harish Harbham explains how to transfer data from Oracle to MS SQL Server. Continue Reading
Oracle expert Harish Harbham explains how Oracle Streams can be used for replication. Continue Reading
Expert Harish Harbham answers the question, "How do you convert SQL Server 2005 database into 0racle 10g?" Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.