Re: RBO to CBO

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 03 Jan 2005 16:39:20 -0800
Message-ID: <41d9e48d$1_4@127.0.0.1>

Niall Litchfield wrote:

> "DA Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:41d6f473_2_at_127.0.0.1...
>

>>But given that Oracle doesn't charge for upgrades if you have a current
>>support contract what is the downside to running the upgrade script and
>>moving up with versions after they have been tested and shown to be
>>stable?

>
>
> Vendor support.
>
>

>>I had a customer this year still running apps with Oracle 7 and a
>>version of forms with a number so small I can't repeat it. Caused them
>>nothing but misery when they were forced by Sarbanes-Oxley to audit
>>system usage. What would have taken less than two minutes with Oracle 9i
>>cost them many tens of thousands of dollars.

>
>
> I'm not sure I get this. Sarbanes-Oxley requirements only take 2 minutes per
> database with 9i? In addition what was the cost of
>
> move from 7-8.0.6-8.1.5-8.1.7-.9.0.1-9.2-10.1 ? in unit testing, client or
> server changes etc.
>
> Then add in the costs of the forms moves and rewrites.
>
> I do like systems to be current, but I'm sure that upgrading every 18 months
> is too costly.

One DBA takes one day to upgrade a system. And most of that time is the computer churning away while the DBA surfs the web. But to be generous 7 days of which DBAs time costs many tens of thousands of dollars? And if you find that guy I want his job.

And yes testing is required. But still the worst case scenario is a financial break-even every time I've costed it out.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Mon Jan 03 2005 - 18:39:20 CST