Re: Advice Wanted: Optimizing Oracle for a Production Environment

In article <bradley.1199000832A_at_aux> bradley_at_aux.marc.usda.gov writes:
>
>Kyle,
> Just my opinion, for what its worth, 80 hours sounds way way way out of
>line unless you already have a huge amount of data stored in the database
>and have a really slow machine. It is not difficult to create a partition
>on a second drive and create a tablespace there for your indexes if you
>already have your database up and running, especially if you saved your
>".sql" files that created your indexes in the first place. Just edit them
>and change the tablespace name.
>
> Now if I may add a question for the real guru's. Is it better to stripe a
>tablespace accross drives and create both index's and data tables there, or
>just put a data tablespace on one drive and an index on the other drive? I
>have two scsi controllers so I can split drives between controllers.

Depends. Application specific.

>
> Thanks,
>
>
>
> Randy
>
>
>
>
>>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.
>>
>
>
>
>
>******************************************************************************
>Randy Bradley | Systems Analyst | US Meat Animal Research Center | Clay Center
>Computer Spec.| 402-762-4156 | bradley_at_aux.marc.usda.gov | Nebraska
>******************************************************************************
>"Around it! Around it! Confoundit. Nobody gave me the specifications. I
>have to do everything myself around here." Gopher-The Great Honeypot Robbery
>-----------------------------------------------------------------------------

-- 
Joel Garry               joelga_at_rossinc.com               Compuserve 70661,1534
These are my opinions, not necessarily those of Ross Systems, Inc.   <> <>
%DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push.            \ V /
panic: ifree: freeing free inodes...                                   O