Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RBO to CBO
Sybrand Bakker wrote:
> On Fri, 31 Dec 2004 23:46:54 -0800, DA Morgan
> <damorgan_at_x.washington.edu> wrote:
>
>
>>Mladen Gogala wrote: >> >> >>>On Thu, 30 Dec 2004 10:04:44 -0800, DA Morgan wrote: >>> >>> >>> >>>>Provided you only use table and index types that existed in Oracle 6. >>> >>> >>>There are many people that only use features of Oracle9 that were >>>available with Oracle 7. Many developers don't know about things >>>like VARRAY, TABLE & CAST operators to access PL/SQL tables and there >>>are even DBAs who have learned about query factoring very short time >>>ago. The category of users implied by your comment is not very small. >> >>I think it is unfortunately the vast majority of developers and DBAs. >>And when it comes to PL/SQL I rarely see anything that couldn't have >>been written in Oracle 7. Cursor loops everywhere and not even a hint >>they know what a BULK COLLECT or FORALL is.
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?
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.
No doubt someone in Sri Lanka argued against a tsunami warning system as being too expensive. My point being that the price will always be paid. It is merely a question of when.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Sat Jan 01 2005 - 13:10:07 CST