Here is an unsophisticated, off-the-cuff, and completely non-sanctioned
guestimate of the situation purely based on my limited view of the Oracle
DB universe - sort of if this was a trivia question, my answer would be
this:
7 - <1%
8i - 3%
9i - 7%
10g - 10%
11g - 15%
12c - 35%
18c - 5%
19c - 25%
Niklas Iveslatt
Senior Partner
Arisant LLC ~ http://www.arisant.com
383 Inverness Parkway, Suite 175 ~ Englewood, CO 80112
mobile: 303.882.4461 ~ main: 303.330.4065 ~ fax: 888.889.0155
Need to send me something securely? *Click here*
<https://arisant.sendsafely.com/u/niklas.iveslatt>
On Fri, Aug 6, 2021 at 3:21 PM Clay Jackson <dmarc-noreply@xxxxxxxxxxxxx>
wrote:
Amen on the gate/test/whatever you want to call it.
At every shop I worked in, we had SOME sort of “test suite” that we
applied to ANY Quarterly Update, Release or major patch that we got from
Oracle; which is why we were usually 2 month behind on the Quarterly
patches. I can’t count the number of “issues” those suites uncovered,
and the list is full of “We applied this patch/update/release and (some
critical SQL) performance went sideways”.
There are lots of ways to do that, from several different vendors,
including Oracle Real Application Testing.
Clay
*From:* oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> *On
Behalf Of *Mark W. Farnham
*Sent:* Friday, August 6, 2021 2:07 PM
*To:* Clay Jackson (cjackson) <Clay.Jackson@xxxxxxxxx>;
ahmed.fikri@xxxxxxxxxxx; 'list, oracle' <oracle-l@xxxxxxxxxxxxx>
*Subject:* RE: Statistics of the Oracle version used in percent
*CAUTION:* This email originated from outside of the organization. Do not
follow guidance, click links, or open attachments unless you recognize the
sender and know the content is safe.
Well said. Those are great reasons for moving forward.
As a gate, a test suite or “regression test” that key features still
worked correctly and that any plan degradations were either still within
performance tolerance or had a count of underflowing performance
requirements that could be handled was also useful.
Larry put it extremely well when he answered why the first release of
Oracle that was sold was “Version 2.” ( “We knew no one would want to buy
version 1”.)
Good luck. I don’t believe you will be able to get a reliable report of
the percentage of each version and patch release in use. I write this with
some confidence that enough sites are prohibited by confidentiality and
security requirements from answering such questions to make any report of
versions in use reliable.
And very likely any report from Oracle Marketing is correlated with
percentage of licensees making some use of the latest release.
Again, good luck.
mwf
*From:* oracle-l-bounce@xxxxxxxxxxxxx [
mailto:oracle-l-bounce@xxxxxxxxxxxxx ;<oracle-l-bounce@xxxxxxxxxxxxx>] *On
Behalf Of *Clay Jackson (Redacted sender "Clay.Jackson" for DMARC)
*Sent:* Friday, August 06, 2021 3:45 PM
*To:* ahmed.fikri@xxxxxxxxxxx; list, oracle
*Subject:* RE: Statistics of the Oracle version used in percent
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
*From:* oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> *On
Behalf Of *ahmed.fikri@xxxxxxxxxxx
*Sent:* Friday, August 6, 2021 12:18 PM
*To:* list, oracle <oracle-l@xxxxxxxxxxxxx>
*Subject:* Statistics of the Oracle version used in percent
*CAUTION:* This email originated from outside of the organization. Do not
follow guidance, click links, or open attachments unless you recognize the
sender and know the content is safe.
Hi all,
Is there a study that shows the percentage of used Oracle versions in
2021? Hopefully not influenced by the Oracle marketing team.
I am also interested in knowing what motivates users to go to a new
version. As well as what scares them to upgrade.
Opinions from some experienced DBAs would be helpful.
Thanks
Ahmed
