me too!
- "Freeman, Robert " <Robert_Freeman_at_csx.com> 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: 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Freeman, Robert
> INET: Robert_Freeman_at_csx.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).
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: wisernet100_at_yahoo.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).
Received on Wed Mar 13 2002 - 16:24:55 CST
