RE: Poll & Questions

I agree with Charlie. Disk is not very expensive.

We have a prod db of about 85GB size. The test/dev env is on other server. They need 100% prod db for regression/volume testing etc. No sub-setting of data is accepted. Whenever they wanted those environment refreshed with prod data, we take a quick cold backup to the spare disks (downtime is less than an hour). And then transfer (ftp/rcp) the files to the target server (3 hours), rename the databases etc, and we are done. This process is in place for a couple of years now. These databases are still running on Oracle 7.3.x.

Convince the Mgmt for additional disks, if you can. The benefit in investing in those is surely worth the cost but again most Damagers follow 'what it costs is more important than what it does' rule. In the absences of those spare disks, we would not have been able to do this cloning with the acceptable amount of downtime, and of course, the turn-around time.

But, in our environment the User Community pays for the disk and not the IT Dept. And that type of Financing works well with us. Sometimes, extremely well :)

• Kirti

-----Original Message-----
Sent: Wednesday, March 13, 2002 8:43 AM
To: Multiple recipients of list ORACLE-L

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: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.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).