Re: Statistics of the Oracle version used in percent

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 6 Aug 2021 22:53:47 -0400
Message-ID: <75ba1829-9368-ee4a-da55-3ed55d8bce9a_at_gmail.com>

Hi Clay!

There is another reason: you are much more likely to find a support analyst with the decent knowledge of the latest and the greatest version than the one with the decent knowledge of an Oracle version two versions behind the current version. And your need for a good analyst will be proportional to the age of your version. The greater the age, the greater the need.

Having said this,  multi-tenancy paradigm, the way Oracle implemented it, is really disappointing. With SQL Server, DBA, MySQL (Oracle might know a bit about MySQL) and Postgres have the ability to backup and restore database easily. No plugging and un-plugging. You can drop database and restore it. Oracle multi-tenant is awkward and ungainly. The idea that single database paradigm will not be supported in the versions newer than 19c has really touched the nerve.

Regards

Don’t know about the percentages, but, when I was a DBA and DBA manager, we upgraded for one (or more) of four reasons, usually in this order

1. There’s a bug fix we need
2. Lack of support (auditors love to jump on this one)
3. Cost of extended support (bean counters will jump on this)
4. There’s a new feature we need (or is required by an application)

 

Clay Jackson

 

 

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

-- http://www.freelists.org/webpage/oracle-l Received on Sat Aug 07 2021 - 04:53:47 CEST