Re: Advice Wanted: Optimizing Oracle for a Production Environment

Kyle,

	You do need to optimize if you expect any kind of load on the
	system, now or in the future.  Bad layouts can kill performance.
	However, the time seems way too high for simply rearranging
	objects to different tablespaces/disk drives, unless you have
	an unbelievably large and complicated system.  The dba may
	be including a lot of other tuning that could be done but I
	would be a little wary.

Kyle wrote:
>
> 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
 

-- 
---
Allen Kirby			AT&T ITS Production Services
akirby_at_att.com			Alpharetta, GA.