Re: Poll & Questions

Given that I saw a 120GB disk for $229 in Sunday's paper, I'm not convinced that the cost of hardware should be an issue. At $50/hour for the DBA, the break even point is less than 5 hours. A development system doesn't need to be fast or contain RAID. It just should be big enough to hold a copy of production.

The compromise we've made here is the production DB run on RAID-0+1 and the development DB run on RAID-5 on a box with fewer and slower CPUs.

Tracy Rahmlow wrote:
>
> We currently have a production, system and development database here. The
> system and development databases are purged periodically and reloaded with
> lookup data. The developers are then responsible for entering transactional
> data in both regions. I am looking to follow the same practice for
> development, however I would like to clone my production database directly to
> the system test database. The production database is ~75G. Management does
> not want to commit $ to a full sized system database. Costs outweigh the
> benefits. I would like to sway them. HOW? Please give me your costs/benefits
> of doing this. In addition, what is the norm (if there can be one) in other
> shops. Does utopia exist?
>
> ps. One of the biggest reasons for this database would be for benchmarking,
> timings, stress-testing. I realize I can copy the production stats, but that
> won't give me a good execution time. Do others load a subset of data (say 25%)
> and then extrapolate to a total time? Is that even necessarily accurate to do?
> I have my doubts. Thanks
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tracy Rahmlow
> INET: Tracy.Rahmlow_at_aexp.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Charlie Mengler                          Maintenance Warehouse  
charliem_at_mwh.com                         10641 Scripps Summit Ct.
858-831-2229                             San Diego, CA 92131    
Lead, follow, or at least have the courtesy to get out of my way!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: charliem_at_mwh.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).