Server A has 16 4GHz single-thread processors, while Server B has 16 2GHZ multi-threaded (8 threads/CPU) processors, so we need to choose between fast, single-threaded processors versus slower, multi-threaded processors. Both servers will have 32 GB of memory.
This server will support a data warehouse used for scientific research, with about 12 users that issue ad-hoc queries via SQLPlus about 95% of the time, each ad-hoc SQL query typically retrieves 10,000+ rows at a time, and DML on user (researcher) tables occurs daily, with 10,000+ inserts, updates, or deletes each time. Because this database supports research efforts, almost no applications exist with optimized SQL queries and researchers are free to issue as many ad-hoc queries as they want and modify their own schema tables as often as needed. Any advice will be greatly appreciated.
Dig Deeper on Oracle database administration
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.