Advice Wanted: Optimizing Oracle for a Production Environment

We are implementing an Oracle based client server integrated system in a manufacturing environment. The software vendor's 2nd DBA told us that we should optimize the structure of the database, i.e. put indexes and tables on separate drives and isolate the Accounting and Manufacturing in different tablespaces. The vendor's first DBA set up the database as if it were in a 'development' environment; not optimized for speed but for simplicity. The 2nd DBA suggested that to optimize the database would take from 80 to 100 hours of work and should be done before implementation. We will be doing approximately 300 invoices a day, minor manufacturing transactions, and moderate other business transactions. I have two questions; First, is it very important that I optimize the database before implementation? and second, is 80 to 100 hours a realistic time frame?

Comments and advice are welcome and will be appreciated.

Kyle Stephens Received on Tue Nov 19 1996 - 00:00:00 CET