me too!
--- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > Anyone besides me seeing old email reappear on the listserv here...? > > RF > > Robert G. Freeman - Oracle8i OCP > Oracle DBA Technical Lead > CSX Midtier Database Administration > > The Cigarette Smoking Man: Anyone who can appease a man's conscience > can > take his freedom away from him. > > > > -----Original Message----- > Sent: Wednesday, March 13, 2002 11:24 AM > To: Multiple recipients of list ORACLE-L > > > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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 > [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Freeman, Robert > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __________________________________________________ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
